| SQL Id | SQL Text |
|---|
| 05s9358mm6vrr | begin dbms_feature_usage_internal.exec_db_usage_sampling(:bind1); end; |
| 0cyf7ts2q1dpg |
SELECT decode ( : P_sortby , 'PO NUMBER' , null , poh . document_buyer_last_name ) , decode ( : P_sortby , 'PO NUMBER' , null , poh . document_buyer_first_name ) , decode ( : po_num_type , 'NUMERIC' , null , poh . po_num ) , decode ( : po_num_type , 'NUMERIC' , decode ( rtrim ( poh . po_num , '0123456789' ) , NULL , to_number ( poh . po_num ) , - 1 ) , null ) , poh . po_type poh_po_type , por . release_type poh_release_type , poh . po_num || decode ( poh . po_type , 'RELEASE' , '-' || por . release_num , null ) poh_po_num , poh . po_num security_poh_po_num , por . release_num security_por_po_num , poh . revision_num poh_revision_num , poh . vendor_name poh_vendor_name , poh . vendor_address_line1 poh_vendor_address_line1 , poh . vendor_address_line2 poh_vendor_address_line2 , poh . vendor_address_line3 poh_vendor_address_line3 , decode ( poh . vendor_city , null , poh . vendor_state || ' ' || poh . vendor_postal_code , poh . vendor_city || ', ' || poh . vendor_state || ' ' || poh . vendor_postal_code ) poh_vendor_adr_info , poh . vendor_country poh_vendor_country , poh . customer_num poh_customer , poh . vendor_num poh_vendor_num , poh . creation_date poh_creation_date , poh . revised_date poh_revised_date , substr ( substr ( poh . document_buyer_first_name , 1 , 1 ) || ' ' || poh . document_buyer_last_name , 1 , 12 ) poh_buyer , substr ( trim ( substr ( poh . archive_buyer_first_name , 1 , 1 ) || ' ' || poh . archive_buyer_last_name ) , 1 , 12 ) poh_archive_buyer , poh . document_buyer_agent_id poh_agent_id , poh . payment_terms poh_payment_terms , poh . ship_via poh_ship_via , poh . fob poh_fob , poh . freight_terms poh_freight_terms , substr ( poh . vendor_contact_first_name , 1 , 1 ) || ' ' || substr ( poh . vendor_contact_last_name , 1 , 10 ) poh_vendor_contact_name , poh . vendor_phone poh_vendor_phone , poh . vendor_contact_phone poh_vendor_contact_phone , poh . note_to_vendor poh_note_to_vendor , poh . printed_date poh_printed_date , poh . amount_agreed poh_amount_agreed , poh . cancel_flag poh_cancel_flag , poh . confirming_order_flag poh_confirming_order_flag , poh . acceptance_required_flag poh_acceptance_req_flag , poh . acceptance_due_date poh_acceptance_due_date , poh . currency_code poh_currency_code , poh . currency_code C_CURRENCY , poh . currency_name poh_currency_name , poh . currency_conversion_rate poh_currency_conversion_rate , poh . bill_to_location_id poh_bill_to_location , poh . ship_to_location_id poh_ship_to_location , poh . po_header_id poh_po_header_id , poh . po_release_id poh_po_release_id , poh . po_type poh_po_type , poh . approved_flag poh_approved_flag , poh . print_count poh_print_count , poh . effective_date poh_effective_date , poh . expiration_date poh_expiration_date , nvl ( poh . po_release_id , - 1 ) poh_join_release_id , poh . vendor_site_id poh_vendor_site_id , poh . vendor_id poh_vendor_id FROM po_headers_print poh , po_releases por WHERE poh . po_release_id = por . po_release_id (+) AND ( nvl ( por . release_num , - 1 ) BETWEEN nvl ( : P_release_num_from , nvl ( por . release_num , - 1 ) ) AND nvl ( : P_release_num_to , nvl ( por . release_num , - 1 ) ) OR poh . po_type != 'RELEASE' ) AND poh . document_buyer_agent_id = nvl ( : P_agent_id , poh . document_buyer_agent_id ) AND ( poh . release_date is NULL OR trunc ( poh . release_date ) BETWEEN nvl ( : P_date_from , trunc ( poh . release_date ) ) AND nvl ( : P_date_to , trunc ( poh . release_date ) + 1 ) ) AND nvl ( poh . approved_flag , 'N' ) = nvl ( : P_approved_flag , nvl ( poh . approved_flag , 'N' ) ) AND ( ( nvl ( : P_print_releases , 'Y' ) = 'Y' ) or ( nvl ( : P_print_releases , 'Y' ) = 'N' and poh . po_type != 'RELEASE' ) ) AND nvl ( poh . consigned_consumption_flag , 'N' ) <> 'Y' AND nvl ( por . consigned_consumption_flag , 'N' ) <> 'Y' AND :P_single_po_print = 1 AND po_num = :P_po_num_from AND nvl(poh.print_
count, 0) =0 AND poh.approved_flag = :P_approved_flag and 1=1 and 1=1 ORDER BY 1 , 2 , 3 , 4 |
| 0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
| 0wmwsjy9kd92f | SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE |
| 15py3q5vknkb9 | BEGIN PO_REQAPPROVAL_INIT1.Start_WF_Process(ItemType => NULL, ItemKey => NULL, WorkflowProcess => NULL, ActionOriginatedFrom => 'PO_FORM', DocumentID => :1, DocumentNumber => :2, PreparerID => :3, DocumentTypeCode => :4, DocumentSubtype => :5, SubmitterAction => 'APPROVE', forwardToID => :6, forwardFromID => :7, DefaultApprovalPathID => :8, Note => :9, PrintFlag => :10, FaxFlag => :11, FaxNumber => :12, EmailFlag => :13, EmailAddress => :14, CreateSourcingRule => :15, UpdateSourcingRule => :16, ReleaseGenMethod => :17, MassUpdateReleases => :18, RetroactivePriceChange => :19, OrgAssignChange => :20, CommunicatePriceChange => :21, p_xml_flag => :22, FpdsngFlag => :23); END; |
| 16614jtsr33r0 | begin fnd_date.initialize_with_calendar(:1, null, :2); end; |
| 1cyrp6fh6mp53 |
SELECT * FROM (SELECT /*+ LEADING(prl) */ prh.requisition_header_id REQUISITION_HEADER_ID , prh.segment1 REQUISITION_NUM , prl.requisition_line_id REQUISITION_LINE_ID , prl.line_num REQUISITION_LINE_NUM , prh.org_id OPERATING_UNIT_ID , nvl(po_moac_utils_pvt.get_ou_shortcode(prh.org_id), po_moac_utils_pvt.get_ou_name(prh.org_id)) ORGANIZATION , prh.type_lookup_code TYPE_LOOKUP_CODE , prl.item_description ITEM_DESCRIPTION , prl.item_id ITEM_ID , msi.concatenated_segments ITEM_NUMBER , prl.item_revision ITEM_REVISION , prl.quantity QUANTITY , prl.need_by_date NEED_BY_DATE , prl.category_id CATEGORY_ID , mc.concatenated_segments CATEGORY , prl.unit_meas_lookup_code UNIT_MEAS_LOOKUP_CODE , prl.unit_price REQ_UNIT_PRICE , DECODE (prl.rfq_required_flag, 'Y', 'RfqRequiredY', 'RfqRequiredN') RFQ_REQUIRED , NVL(prl.rfq_required_flag, 'N') RFQ_REQUIRED_FLAG , NVL(prl.on_rfq_flag, 'N') ON_RFQ_FLAG , NVL(prl.drop_ship_flag, 'N') DROP_SHIP_FLAG , prl.suggested_vendor_name SUGGESTED_VENDOR_NAME , prl.vendor_id VENDOR_ID , prl.suggested_vendor_location SUGGESTED_VENDOR_LOC , prl.vendor_site_id VENDOR_SITE_ID , DECODE(prl.order_type_lookup_code, 'FIXED PRICE', prl.amount, 'RATE', prl.amount, prl.quantity * prl.unit_price) REQ_AMOUNT , req_sob.currency_code REQ_CURRENCY_CODE , prl.bid_line_number BID_LINE_NUMBER , prl.bid_number BID_NUMBER , prl.suggested_buyer_id SUGGESTED_BUYER_ID , buyer.full_name SUGGESTED_BUYER , prh.creation_date CREATION_DATE , prl.currency_code FOREIGN_CURRENCY_CODE , DECODE(prl.order_type_lookup_code, 'FIXED PRICE', prl.currency_amount, 'RATE', prl.currency_amount, prl.quantity * prl.currency_unit_price) FOREIGN_CURRENCY_AMT , decode(pltb.purchase_basis, 'GOODS', prl.currency_unit_price , 'SERVICES', decode(prl.order_type_lookup_code , 'FIXED PRICE', prl.amount , 'AMOUNT', prl.quantity * prl.currency_unit_price) , 'TEMP LABOR', prl.currency_unit_price ) FOREIGN_CURRENCY_UNIT_PRICE , prl.deliver_to_location_id DELIVER_TO_LOCATION_ID , NVL(deliver_hrtl.location_code, SUBSTRB(rtrim(deliver_hz.address1)||'-'||rtrim(deliver_hz.city), 1, 20)) DELIVER_TO_LOCATION , prl.destination_organization_id DESTINATION_ORGANIZATION_ID , dst_hou.name DESTINATION_ORGANIZATION , prl.destination_subinventory DESTINATION_SUBINVENTORY , prl.destination_type_code DESTINATION_TYPE_CODE , NVL(deliver_hr.ship_to_location_id, deliver_hz.location_id) SHIP_TO_LOCATION_ID , prh.emergency_po_num EMERGENCY_PO_NUM , prh.emergency_po_org_id EMERGENCY_PO_ORG_ID , DECODE(prl.encumbered_flag, 'Y', 'EncumberedY', 'EncumberedN') ENCUMBERED , NVL(prl.encumbered_flag, 'N') ENCUMBERED_FLAG , prl.assignment_end_date ASSIGNMENT_END_DATE , prl.candidate_first_name CANDIDATE_FIRST_NAME , prl.suggested_vendor_contact SUGGESTED_VENDOR_CONTACT , prl.hazard_class_id HAZARD_CLASS_ID , prh.interface_source_code IMPORT_SOURCE_CODE , prl.job_id JOB_ID , prl.justification JUSTIFICATION , prl.candidate_last_name CANDIDATE_LAST_NAME , DECODE(SIGN(SYSDATE - NVL(prl.need_by_date, SYSDATE) - NVL(msi.full_lead_time, 0)), 1, 'Y', 'N') LATE_FLAG , DECODE(prl.modified_by_agent_flag, 'Y', 'ModifiedY', 'ModifiedN') MODIFIED , prl.auction_line_number NEGOTIATION_LINE_NUMBER , prl.auction_display_number NEGOTIATION_NUMBER , prl.note_to_agent NOTE_TO_BUYER , prl.note_to_receiver NOTE_TO_RECEIVER , prl.wip_operation_seq_num OPERATION_SEQUENCE , prl.wip_repetitive_schedule_id REPETITIVE_SCHEDULE_ID , DECODE(NVL(prl.pcard_flag, 'N'), 'N', TO_NUMBER(NULL), 'S', -99999, prh.pcard_id) PCARD_ID , prl.suggested_vendor_phone SUGGESTED_VENDOR_PHONE , prl.preferred_grade PREFERRED_GRADE , preparer.full_name PREPARER , prh.preparer_id PREPARER_ID , prl.quantity_received QUANTITY_RECEIVED , prl.rate FOREIGN_CURRENCY_RATE , prl.rate_date FOREIGN_CURRENCY_RATE_DATE , prl.rate_type FOREIGN_CURRENCY_RATE_TYPE , prl.reference_num REFERENCE_NUM , requester.full_name REQUESTER , prl.to_person_id R
EQUESTER_ID , prh.description REQUISITION_DESCRIPTION , prl.bom_resource_id BOM_RESOURCE_ID , prl.wip_resource_seq_num RESOURCE_SEQUENCE , prl.secondary_quantity SECONDARY_QUANTITY , prl.secondary_unit_of_measure SECONDARY_UNIT_OF_MEASURE , prl.blanket_po_line_num SOURCE_DOCUMENT_LINE , src_doc.segment1 SOURCE_DOCUMENT_NUM , prl.blanket_po_header_id SOURCE_DOCUMENT_ID , src_doc.org_id SOURCE_DOCUMENT_ORG_ID , prl.document_type_code SOURCE_DOC_TYPE_CODE , NVL(src_doc.global_agreement_flag, 'N') GLOBAL_FLAG , DECODE (src_doc.global_agreement_flag, 'Y', 'GlobalY', 'GlobalN') GLOBAL , DECODE (prl.blanket_po_header_id, NULL, 'N', 'Y') REQ_SOURCED_FLAG , prl.oke_contract_header_id OKE_CONTRACT_HEADER_ID , prl.assignment_start_date ASSIGNMENT_START_DATE , DECODE (prl.new_supplier_flag, 'Y', 'NewSupplierY', 'NewSupplierN') NEW_SUPPLIER , NVL(prl.new_supplier_flag, 'N') NEW_SUPPLIER_FLAG , prl.supplier_ref_number SUPPLIER_CONFIG_ID , prl.suggested_vendor_contact_email SUGGESTED_VENDOR_EMAIL , prl.suggested_vendor_contact_fax SUGGESTED_VENDOR_FAX , prl.suggested_vendor_product_code SUPPLIER_ITEM , prl.ussgl_transaction_code TRANSACTION_CODE , prl.transaction_reason_code TRANSACTION_REASON , plttl.line_type LINE_TYPE_DSP , pltb.line_type_id LINE_TYPE_ID , pltb.order_type_lookup_code ORDER_TYPE_LOOKUP_CODE , pltb.purchase_basis PURCHASE_BASIS , pltb.matching_basis MATCHING_BASIS , prl.labor_req_line_id LABOR_REQ_LINE_ID , DECODE (prl.suggested_buyer_id, NULL, 'Y', 'N') UNASSIGNED_FLAG , prl.un_number_id UN_NUMBER_ID , DECODE (prl.urgent_flag, 'Y', 'UrgentY', 'UrgentN') URGENT , NVL(prl.urgent_flag, 'N') URGENT_FLAG , DECODE (prl.vmi_flag, 'Y', 'VmiY', 'VmiN') VMI , NVL(prl.vmi_flag, 'N') VMI_FLAG , prl.wip_entity_id WIP_ENTITY_ID , prl.wip_line_id WIP_LINE_ID , NVL(prh.authorization_status, 'INCOMPLETE') AUTHORIZATION_STATUS , prl.attribute_category ATTRIBUTE_CATEGORY , prl.attribute1 ATTRIBUTE1 , prl.attribute2 ATTRIBUTE2 , prl.attribute3 ATTRIBUTE3 , prl.attribute4 ATTRIBUTE4 , prl.attribute5 ATTRIBUTE5 , prl.attribute6 ATTRIBUTE6 , prl.attribute7 ATTRIBUTE7 , prl.attribute8 ATTRIBUTE8 , prl.attribute9 ATTRIBUTE9 , prl.attribute10 ATTRIBUTE10 , prl.attribute11 ATTRIBUTE11 , prl.attribute12 ATTRIBUTE12 , prl.attribute13 ATTRIBUTE13 , prl.attribute14 ATTRIBUTE14 , prl.attribute15 ATTRIBUTE15 , req_fsp.inventory_organization_id BASE_INV_ORGANIZATION_ID , prl.auction_header_id AUCTION_HEADER_ID , prh.segment1 ||', ' || prl.line_num REQUEST , nvl( msi.concatenated_segments, prl.item_description) ITEM , decode(pltb.purchase_basis, 'GOODS', prl.unit_price , 'SERVICES', decode(prl.order_type_lookup_code , 'FIXED PRICE', prl.amount , 'AMOUNT', prl.quantity * prl.unit_price) , 'TEMP LABOR', prl.unit_price ) PRICE , prl.vendor_contact_id VENDOR_CONTACT_ID , prl.PARENT_REQ_LINE_ID , prl.source_type_code , ( SELECT 'Y' FROM dual WHERE exists ( SELECT 'Y' FROM po_req_distributions_all prd WHERE prd.requisition_line_id=prl.requisition_line_id AND prd.award_id is not null ) )AWARD_EXISTS , prl.kanban_card_id , src_doc.style_id SOURCE_DOCUMENT_STYLE_ID , src_doc_line.po_line_id SOURCE_DOCUMENT_LINE_ID FROM po_requisition_headers_all prh, po_requisition_lines prl, hr_all_organization_units_tl hou, po_line_types_tl plttl, po_line_types_b pltb, po_headers_all src_doc, po_lines_all src_doc_line, hr_all_organization_units_tl dst_hou, mtl_system_items_b_kfv msi, mtl_categories_kfv mc, per_all_people_f buyer, per_all_people_f requester, per_all_people_f preparer, hr_locations_all_tl deliver_hrtl, hr_locations_all deliver_hr, hz_locations deliver_hz, financials_system_params_all req_fsp, gl_sets_of_books req_sob WHERE prl.requisition_header_id = prh.requisition_header_id AND hou.organization_id (+) = prl.org_id AND req_fsp.org_id = prl.org_id AND hou.language (+) = userenv('LANG') AND pltb.line_type_id = prl.line_type_id AND plttl.line_type_id = pltb.line_type_
id AND plttl.language = userenv('LANG') AND src_doc.po_header_id (+) = prl.blanket_po_header_id AND src_doc_line.po_header_id(+) = prl.blanket_po_header_id AND src_doc_line.line_num(+) = prl.blanket_po_line_num AND dst_hou.organization_id (+) = prl.destination_organization_id AND dst_hou.language (+) = userenv('LANG') AND msi.inventory_item_id (+) = prl.item_id AND msi.organization_id (+) = prl.destination_organization_id AND mc.category_id = prl.category_id AND buyer.person_id (+) = prl.suggested_buyer_id AND TRUNC(sysdate) BETWEEN buyer.effective_start_date(+) AND buyer.effective_end_date(+) AND requester.person_id = prl.to_person_id AND TRUNC(sysdate) BETWEEN requester.effective_start_date AND requester.effective_end_date AND preparer.person_id = prh.preparer_id AND TRUNC(sysdate) BETWEEN preparer.effective_start_date AND preparer.effective_end_date AND deliver_hr.location_id(+) = prl.deliver_to_location_id AND deliver_hrtl.location_id (+) = deliver_hr.location_id AND deliver_hrtl.language (+) = USERENV('LANG') AND deliver_hz.location_id(+) = prl.deliver_to_location_id AND req_fsp.set_of_books_id = req_sob.set_of_books_id AND prl.reqs_in_pool_flag = 'Y' AND ( NOT (pltb.order_type_lookup_code = 'RATE' AND pltb.purchase_basis = 'TEMP LABOR' AND EXISTS (SELECT 'Corresponding expense line not in pool' FROM po_requisition_lines_all expense_line WHERE expense_line.labor_req_line_id = prl.requisition_line_id AND expense_line.reqs_in_pool_flag is null))) AND ( NOT (pltb.order_type_lookup_code = 'FIXED PRICE' AND pltb.purchase_basis = 'SERVICES' AND EXISTS (SELECT 'Corresponding labor line not in pool' FROM po_requisition_lines_all labor_line WHERE labor_line.requisition_line_id = prl.labor_req_line_id AND labor_line.reqs_in_pool_flag is null))) AND NVL(prh.authorization_status, 'INCOMPLETE') NOT IN ('SYSTEM_SAVED', 'RETURNED') AND prl.requisition_line_id NOT IN (SELECT doc_builder.index_num1 FROM po_session_gt doc_builder WHERE doc_builder.key = :1) AND DECODE(FND_PROFILE.VALUE('PO_AUTOCREATE_ALLOW_BUYER_OVERRIDE'), 'Y', FND_GLOBAL.EMPLOYEE_ID, 'N', PRL.SUGGESTED_BUYER_ID, FND_GLOBAL.EMPLOYEE_ID)=FND_GLOBAL.EMPLOYEE_ID) QRSLT WHERE (requisition_line_id IN ( SELECT selected_req_lines.index_num1 FROM po_session_gt selected_req_lines WHERE selected_req_lines.key = :2 )) ORDER BY CREATION_DATE desc, ORGANIZATION, TO_NUMBER(REQUISITION_NUM) DESC, REQUISITION_LINE_NUM DESC |
| 2450j0nxcnga5 | declare sql_dummy1 boolean;begin fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, sql_dummy1, :org_id, :server_id);end; |
| 327r1ynryuzvw | begin PO_REQAPPROVAL_ACTION.APPROVE_DOC (:v1, :v2, :v3, :v4, :v5); end; |
| 37kp7bjxfn4u5 | SELECT NLS_DATE_LANGUAGE FROM (SELECT UTF8_DATE_LANGUAGE NLS_DATE_LANGUAGE FROM FND_LANGUAGES WHERE NLS_CHARSET_NAME(NLS_CHARSET_ID('CHAR_CS')) IN ('UTF8', 'AL32UTF8') AND INSTALLED_FLAG <>'D' AND NLS_LANGUAGE = :B1 UNION SELECT LOCAL_DATE_LANGUAGE NLS_DATE_LANGUAGE FROM FND_LANGUAGES WHERE NLS_CHARSET_NAME(NLS_CHARSET_ID('CHAR_CS')) NOT IN ('UTF8', 'AL32UTF8') AND INSTALLED_FLAG <>'D' AND NLS_LANGUAGE = :B1 ) |
| 3h1rjtcff3wy1 | BEGIN ordsys.CARTRIDGE.dbms_feature_multimedia(:feature_boolean, :aux_cnt, :feature_info); END; |
| 3mhu25sfw466x | begin :1 := POR_UTIL_PKG.submitreq(:2, :3, :4, :5, :6); end; |
| 3v6p5sm1dkafz |
SELECT * FROM (SELECT /*+ LEADING(prl) */ prh.requisition_header_id REQUISITION_HEADER_ID , prh.segment1 REQUISITION_NUM , prl.requisition_line_id REQUISITION_LINE_ID , prl.line_num REQUISITION_LINE_NUM , prh.org_id OPERATING_UNIT_ID , nvl(po_moac_utils_pvt.get_ou_shortcode(prh.org_id), po_moac_utils_pvt.get_ou_name(prh.org_id)) ORGANIZATION , prh.type_lookup_code TYPE_LOOKUP_CODE , prl.item_description ITEM_DESCRIPTION , prl.item_id ITEM_ID , msi.concatenated_segments ITEM_NUMBER , prl.item_revision ITEM_REVISION , prl.quantity QUANTITY , prl.need_by_date NEED_BY_DATE , prl.category_id CATEGORY_ID , mc.concatenated_segments CATEGORY , prl.unit_meas_lookup_code UNIT_MEAS_LOOKUP_CODE , prl.unit_price REQ_UNIT_PRICE , DECODE (prl.rfq_required_flag, 'Y', 'RfqRequiredY', 'RfqRequiredN') RFQ_REQUIRED , NVL(prl.rfq_required_flag, 'N') RFQ_REQUIRED_FLAG , NVL(prl.on_rfq_flag, 'N') ON_RFQ_FLAG , NVL(prl.drop_ship_flag, 'N') DROP_SHIP_FLAG , prl.suggested_vendor_name SUGGESTED_VENDOR_NAME , prl.vendor_id VENDOR_ID , prl.suggested_vendor_location SUGGESTED_VENDOR_LOC , prl.vendor_site_id VENDOR_SITE_ID , DECODE(prl.order_type_lookup_code, 'FIXED PRICE', prl.amount, 'RATE', prl.amount, prl.quantity * prl.unit_price) REQ_AMOUNT , req_sob.currency_code REQ_CURRENCY_CODE , prl.bid_line_number BID_LINE_NUMBER , prl.bid_number BID_NUMBER , prl.suggested_buyer_id SUGGESTED_BUYER_ID , buyer.full_name SUGGESTED_BUYER , prh.creation_date CREATION_DATE , prl.currency_code FOREIGN_CURRENCY_CODE , DECODE(prl.order_type_lookup_code, 'FIXED PRICE', prl.currency_amount, 'RATE', prl.currency_amount, prl.quantity * prl.currency_unit_price) FOREIGN_CURRENCY_AMT , decode(pltb.purchase_basis, 'GOODS', prl.currency_unit_price , 'SERVICES', decode(prl.order_type_lookup_code , 'FIXED PRICE', prl.amount , 'AMOUNT', prl.quantity * prl.currency_unit_price) , 'TEMP LABOR', prl.currency_unit_price ) FOREIGN_CURRENCY_UNIT_PRICE , prl.deliver_to_location_id DELIVER_TO_LOCATION_ID , NVL(deliver_hrtl.location_code, SUBSTRB(rtrim(deliver_hz.address1)||'-'||rtrim(deliver_hz.city), 1, 20)) DELIVER_TO_LOCATION , prl.destination_organization_id DESTINATION_ORGANIZATION_ID , dst_hou.name DESTINATION_ORGANIZATION , prl.destination_subinventory DESTINATION_SUBINVENTORY , prl.destination_type_code DESTINATION_TYPE_CODE , NVL(deliver_hr.ship_to_location_id, deliver_hz.location_id) SHIP_TO_LOCATION_ID , prh.emergency_po_num EMERGENCY_PO_NUM , prh.emergency_po_org_id EMERGENCY_PO_ORG_ID , DECODE(prl.encumbered_flag, 'Y', 'EncumberedY', 'EncumberedN') ENCUMBERED , NVL(prl.encumbered_flag, 'N') ENCUMBERED_FLAG , prl.assignment_end_date ASSIGNMENT_END_DATE , prl.candidate_first_name CANDIDATE_FIRST_NAME , prl.suggested_vendor_contact SUGGESTED_VENDOR_CONTACT , prl.hazard_class_id HAZARD_CLASS_ID , prh.interface_source_code IMPORT_SOURCE_CODE , prl.job_id JOB_ID , prl.justification JUSTIFICATION , prl.candidate_last_name CANDIDATE_LAST_NAME , DECODE(SIGN(SYSDATE - NVL(prl.need_by_date, SYSDATE) - NVL(msi.full_lead_time, 0)), 1, 'Y', 'N') LATE_FLAG , DECODE(prl.modified_by_agent_flag, 'Y', 'ModifiedY', 'ModifiedN') MODIFIED , prl.auction_line_number NEGOTIATION_LINE_NUMBER , prl.auction_display_number NEGOTIATION_NUMBER , prl.note_to_agent NOTE_TO_BUYER , prl.note_to_receiver NOTE_TO_RECEIVER , prl.wip_operation_seq_num OPERATION_SEQUENCE , prl.wip_repetitive_schedule_id REPETITIVE_SCHEDULE_ID , DECODE(NVL(prl.pcard_flag, 'N'), 'N', TO_NUMBER(NULL), 'S', -99999, prh.pcard_id) PCARD_ID , prl.suggested_vendor_phone SUGGESTED_VENDOR_PHONE , prl.preferred_grade PREFERRED_GRADE , preparer.full_name PREPARER , prh.preparer_id PREPARER_ID , prl.quantity_received QUANTITY_RECEIVED , prl.rate FOREIGN_CURRENCY_RATE , prl.rate_date FOREIGN_CURRENCY_RATE_DATE , prl.rate_type FOREIGN_CURRENCY_RATE_TYPE , prl.reference_num REFERENCE_NUM , requester.full_name REQUESTER , prl.to_person_id R
EQUESTER_ID , prh.description REQUISITION_DESCRIPTION , prl.bom_resource_id BOM_RESOURCE_ID , prl.wip_resource_seq_num RESOURCE_SEQUENCE , prl.secondary_quantity SECONDARY_QUANTITY , prl.secondary_unit_of_measure SECONDARY_UNIT_OF_MEASURE , prl.blanket_po_line_num SOURCE_DOCUMENT_LINE , src_doc.segment1 SOURCE_DOCUMENT_NUM , prl.blanket_po_header_id SOURCE_DOCUMENT_ID , src_doc.org_id SOURCE_DOCUMENT_ORG_ID , prl.document_type_code SOURCE_DOC_TYPE_CODE , NVL(src_doc.global_agreement_flag, 'N') GLOBAL_FLAG , DECODE (src_doc.global_agreement_flag, 'Y', 'GlobalY', 'GlobalN') GLOBAL , DECODE (prl.blanket_po_header_id, NULL, 'N', 'Y') REQ_SOURCED_FLAG , prl.oke_contract_header_id OKE_CONTRACT_HEADER_ID , prl.assignment_start_date ASSIGNMENT_START_DATE , DECODE (prl.new_supplier_flag, 'Y', 'NewSupplierY', 'NewSupplierN') NEW_SUPPLIER , NVL(prl.new_supplier_flag, 'N') NEW_SUPPLIER_FLAG , prl.supplier_ref_number SUPPLIER_CONFIG_ID , prl.suggested_vendor_contact_email SUGGESTED_VENDOR_EMAIL , prl.suggested_vendor_contact_fax SUGGESTED_VENDOR_FAX , prl.suggested_vendor_product_code SUPPLIER_ITEM , prl.ussgl_transaction_code TRANSACTION_CODE , prl.transaction_reason_code TRANSACTION_REASON , plttl.line_type LINE_TYPE_DSP , pltb.line_type_id LINE_TYPE_ID , pltb.order_type_lookup_code ORDER_TYPE_LOOKUP_CODE , pltb.purchase_basis PURCHASE_BASIS , pltb.matching_basis MATCHING_BASIS , prl.labor_req_line_id LABOR_REQ_LINE_ID , DECODE (prl.suggested_buyer_id, NULL, 'Y', 'N') UNASSIGNED_FLAG , prl.un_number_id UN_NUMBER_ID , DECODE (prl.urgent_flag, 'Y', 'UrgentY', 'UrgentN') URGENT , NVL(prl.urgent_flag, 'N') URGENT_FLAG , DECODE (prl.vmi_flag, 'Y', 'VmiY', 'VmiN') VMI , NVL(prl.vmi_flag, 'N') VMI_FLAG , prl.wip_entity_id WIP_ENTITY_ID , prl.wip_line_id WIP_LINE_ID , NVL(prh.authorization_status, 'INCOMPLETE') AUTHORIZATION_STATUS , prl.attribute_category ATTRIBUTE_CATEGORY , prl.attribute1 ATTRIBUTE1 , prl.attribute2 ATTRIBUTE2 , prl.attribute3 ATTRIBUTE3 , prl.attribute4 ATTRIBUTE4 , prl.attribute5 ATTRIBUTE5 , prl.attribute6 ATTRIBUTE6 , prl.attribute7 ATTRIBUTE7 , prl.attribute8 ATTRIBUTE8 , prl.attribute9 ATTRIBUTE9 , prl.attribute10 ATTRIBUTE10 , prl.attribute11 ATTRIBUTE11 , prl.attribute12 ATTRIBUTE12 , prl.attribute13 ATTRIBUTE13 , prl.attribute14 ATTRIBUTE14 , prl.attribute15 ATTRIBUTE15 , req_fsp.inventory_organization_id BASE_INV_ORGANIZATION_ID , prl.auction_header_id AUCTION_HEADER_ID , prh.segment1 ||', ' || prl.line_num REQUEST , nvl( msi.concatenated_segments, prl.item_description) ITEM , decode(pltb.purchase_basis, 'GOODS', prl.unit_price , 'SERVICES', decode(prl.order_type_lookup_code , 'FIXED PRICE', prl.amount , 'AMOUNT', prl.quantity * prl.unit_price) , 'TEMP LABOR', prl.unit_price ) PRICE , prl.vendor_contact_id VENDOR_CONTACT_ID , prl.PARENT_REQ_LINE_ID , prl.source_type_code , ( SELECT 'Y' FROM dual WHERE exists ( SELECT 'Y' FROM po_req_distributions_all prd WHERE prd.requisition_line_id=prl.requisition_line_id AND prd.award_id is not null ) )AWARD_EXISTS , prl.kanban_card_id , src_doc.style_id SOURCE_DOCUMENT_STYLE_ID , src_doc_line.po_line_id SOURCE_DOCUMENT_LINE_ID FROM po_requisition_headers_all prh, po_requisition_lines prl, hr_all_organization_units_tl hou, po_line_types_tl plttl, po_line_types_b pltb, po_headers_all src_doc, po_lines_all src_doc_line, hr_all_organization_units_tl dst_hou, mtl_system_items_b_kfv msi, mtl_categories_kfv mc, per_all_people_f buyer, per_all_people_f requester, per_all_people_f preparer, hr_locations_all_tl deliver_hrtl, hr_locations_all deliver_hr, hz_locations deliver_hz, financials_system_params_all req_fsp, gl_sets_of_books req_sob WHERE prl.requisition_header_id = prh.requisition_header_id AND hou.organization_id (+) = prl.org_id AND req_fsp.org_id = prl.org_id AND hou.language (+) = userenv('LANG') AND pltb.line_type_id = prl.line_type_id AND plttl.line_type_id = pltb.line_type_
id AND plttl.language = userenv('LANG') AND src_doc.po_header_id (+) = prl.blanket_po_header_id AND src_doc_line.po_header_id(+) = prl.blanket_po_header_id AND src_doc_line.line_num(+) = prl.blanket_po_line_num AND dst_hou.organization_id (+) = prl.destination_organization_id AND dst_hou.language (+) = userenv('LANG') AND msi.inventory_item_id (+) = prl.item_id AND msi.organization_id (+) = prl.destination_organization_id AND mc.category_id = prl.category_id AND buyer.person_id (+) = prl.suggested_buyer_id AND TRUNC(sysdate) BETWEEN buyer.effective_start_date(+) AND buyer.effective_end_date(+) AND requester.person_id = prl.to_person_id AND TRUNC(sysdate) BETWEEN requester.effective_start_date AND requester.effective_end_date AND preparer.person_id = prh.preparer_id AND TRUNC(sysdate) BETWEEN preparer.effective_start_date AND preparer.effective_end_date AND deliver_hr.location_id(+) = prl.deliver_to_location_id AND deliver_hrtl.location_id (+) = deliver_hr.location_id AND deliver_hrtl.language (+) = USERENV('LANG') AND deliver_hz.location_id(+) = prl.deliver_to_location_id AND req_fsp.set_of_books_id = req_sob.set_of_books_id AND prl.reqs_in_pool_flag = 'Y' AND ( NOT (pltb.order_type_lookup_code = 'RATE' AND pltb.purchase_basis = 'TEMP LABOR' AND EXISTS (SELECT 'Corresponding expense line not in pool' FROM po_requisition_lines_all expense_line WHERE expense_line.labor_req_line_id = prl.requisition_line_id AND expense_line.reqs_in_pool_flag is null))) AND ( NOT (pltb.order_type_lookup_code = 'FIXED PRICE' AND pltb.purchase_basis = 'SERVICES' AND EXISTS (SELECT 'Corresponding labor line not in pool' FROM po_requisition_lines_all labor_line WHERE labor_line.requisition_line_id = prl.labor_req_line_id AND labor_line.reqs_in_pool_flag is null))) AND NVL(prh.authorization_status, 'INCOMPLETE') NOT IN ('SYSTEM_SAVED', 'RETURNED') AND prl.requisition_line_id NOT IN (SELECT doc_builder.index_num1 FROM po_session_gt doc_builder WHERE doc_builder.key = :1) AND DECODE(FND_PROFILE.VALUE('PO_AUTOCREATE_ALLOW_BUYER_OVERRIDE'), 'Y', FND_GLOBAL.EMPLOYEE_ID, 'N', PRL.SUGGESTED_BUYER_ID, FND_GLOBAL.EMPLOYEE_ID)=FND_GLOBAL.EMPLOYEE_ID) QRSLT WHERE ((suggested_buyer_id = :2 AND ship_to_location_id = :3)) ORDER BY CREATION_DATE desc, ORGANIZATION, TO_NUMBER(REQUISITION_NUM) DESC, REQUISITION_LINE_NUM DESC |
| 4kk0bjar3pb7z | SELECT PLI.SHIPMENT_NUM , PLI.REQUISITION_LINE_ID FROM PO_LINES_INTERFACE PLI, PO_REQUISITION_LINES_ALL PRL, MTL_SYSTEM_ITEMS MSI , PO_LINE_TYPES PLT , PO_SYSTEM_PARAMETERS_ALL PSP , FINANCIALS_SYSTEM_PARAMS_ALL FSP, PO_VENDORS POV, PO_HEADERS_INTERFACE PHI WHERE PLI.LINE_NUM = :B10 AND PLI.SHIPMENT_NUM IS NOT NULL AND NVL(PSP.ORG_ID, -99) = NVL(:B9 , -99) AND NVL(FSP.ORG_ID, -99) = NVL(:B9 , -99) AND PLI.ITEM_ID = MSI.INVENTORY_ITEM_ID(+) AND NVL(MSI.ORGANIZATION_ID, FSP.INVENTORY_ORGANIZATION_ID)= FSP.INVENTORY_ORGANIZATION_ID AND PLI.LINE_TYPE_ID = PLT.LINE_TYPE_ID AND PHI.VENDOR_ID = POV.VENDOR_ID (+) AND PLI.INTERFACE_HEADER_ID = PHI.INTERFACE_HEADER_ID AND PRL.REQUISITION_LINE_ID <> :B8 AND PRL.REQUISITION_LINE_ID = PLI.REQUISITION_LINE_ID AND ( ( TO_CHAR(PLI.NEED_BY_DATE-(TO_NUMBER(SUBSTR(TO_CHAR(PLI.NEED_BY_DATE, 'DD-MM-YYYY HH24:MI:SS'), 18, 2))/86400), 'DD-MM-YYYY HH24:MI:SS') = TO_CHAR(:B7 -(TO_NUMBER(SUBSTR(TO_CHAR(:B7 , 'DD-MM-YYYY HH24:MI:SS'), 18, 2))/86400), 'DD-MM-YYYY HH24:MI:SS') ) OR (PLI.NEED_BY_DATE IS NULL AND :B7 IS NULL) ) AND NVL(PLI.DROP_SHIP_FLAG, 'N') <> 'Y' AND RTRIM(NVL(PLI.NOTE_TO_RECEIVER, '99')) = RTRIM(NVL(:B6 , '99')) AND EXISTS (SELECT 'x' FROM HR_LOCATIONS HRL WHERE PRL.DELIVER_TO_LOCATION_ID = HRL.LOCATION_ID AND NVL(HRL.SHIP_TO_LOCATION_ID, HRL.LOCATION_ID) = :B11 UNION ALL SELECT 'x' FROM HZ_LOCATIONS HZ WHERE PRL.DELIVER_TO_LOCATION_ID = HZ.LOCATION_ID AND HZ.LOCATION_ID = :B11 ) AND PRL.DESTINATION_ORGANIZATION_ID = :B5 AND DECODE(PRL.DESTINATION_TYPE_CODE, 'EXPENSE', DECODE(NVL(MSI.RECEIPT_REQUIRED_FLAG, NVL(PLT.RECEIVING_FLAG, NVL(POV.RECEIPT_REQUIRED_FLAG, NVL(PSP.RECEIVING_FLAG, 'N')))), 'N', 'N', DECODE(PSP.EXPENSE_ACCRUAL_CODE, 'PERIOD END', 'N', 'Y')), 'INVENTORY', 'Y', 'SHOP FLOOR', 'Y') = :B4 AND ( ( PLI.PREFERRED_GRADE IS NULL AND :B3 IS NULL ) OR ( PLI.PREFERRED_GRADE = :B3 ) ) AND NVL(PLI.VMI_FLAG, 'N') = NVL(:B2 , 'N') AND NVL(PLI.CONSIGNED_FLAG, 'N') = NVL(:B1 , 'N') AND ROWNUM = 1 |
| 4mj8xhjcnw7gf |
SELECT "A2"."SHIPMENT_NUM" "SHIPMENT_NUM", "A2"."DUE_DATE" "DUE_DATE", "A2"."QUANTITY" "QUANTITY", "A2"."PRICE_OVERRIDE" "PRICE_OVERRIDE", "A2"."QUANTITY_CANCELLED" "QUANTITY_CANCELLED", "A2"."CANCEL_FLAG" "CANCEL_FLAG", "A2"."CANCEL_DATE" "CANCEL_DATE", "A2"."CANCEL_REASON" "CANCEL_REASON", "A2"."TAXABLE_FLAG" "TAXABLE_FLAG", "A2"."START_DATE" "START_DATE", "A2"."END_DATE" "END_DATE", "A2"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A2"."ATTRIBUTE1" "ATTRIBUTE1", "A2"."ATTRIBUTE2" "ATTRIBUTE2", "A2"."ATTRIBUTE3" "ATTRIBUTE3", "A2"."ATTRIBUTE4" "ATTRIBUTE4", "A2"."ATTRIBUTE5" "ATTRIBUTE5", "A2"."ATTRIBUTE6" "ATTRIBUTE6", "A2"."ATTRIBUTE7" "ATTRIBUTE7", "A2"."ATTRIBUTE8" "ATTRIBUTE8", "A2"."ATTRIBUTE9" "ATTRIBUTE9", "A2"."ATTRIBUTE10" "ATTRIBUTE10", "A2"."ATTRIBUTE11" "ATTRIBUTE11", "A2"."ATTRIBUTE12" "ATTRIBUTE12", "A2"."ATTRIBUTE13" "ATTRIBUTE13", "A2"."ATTRIBUTE14" "ATTRIBUTE14", "A2"."ATTRIBUTE15" "ATTRIBUTE15", "A2"."PO_HEADER_ID" "PO_HEADER_ID", "A2"."PO_LINE_ID" "PO_LINE_ID", "A2"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A2"."SHIPMENT_TYPE" "SHIPMENT_TYPE", "A2"."PO_RELEASE_ID" "PO_RELEASE_ID", "A2"."CONSIGNED_FLAG" "CONSIGNED_FLAG", "A2"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A2"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A2"."RECEIVING_ROUTING_ID" "RECEIVING_ROUTING_ID", "A2"."ACCRUE_ON_RECEIPT_FLAG" "ACCRUE_ON_RECEIPT_FLAG", "A2"."CLOSED_REASON" "CLOSED_REASON", "A2"."CLOSED_DATE" "CLOSED_DATE", "A2"."CLOSED_BY" "CLOSED_BY", "A2"."ORG_ID" "ORG_ID", "A2"."UNIT_OF_MEASURE_CLASS" "UNIT_OF_MEASURE_CLASS", "A2"."ENCUMBER_NOW" "ENCUMBER_NOW", "A2"."INSPECTION_REQUIRED_FLAG" "INSPECTION_REQUIRED_FLAG", "A2"."RECEIPT_REQUIRED_FLAG" "RECEIPT_REQUIRED_FLAG", "A2"."QTY_RCV_TOLERANCE" "QTY_RCV_TOLERANCE", "A2"."QTY_RCV_EXCEPTION_CODE" "QTY_RCV_EXCEPTION_CODE", "A2"."ENFORCE_SHIP_TO_LOCATION_CODE" "ENFORCE_SHIP_TO_LOCATION_CODE", "A2"."ALLOW_SUBSTITUTE_RECEIPTS_FLAG" "ALLOW_SUBSTITUTE_RECEIPTS_FLAG", "A2"."DAYS_EARLY_RECEIPT_ALLOWED" "DAYS_EARLY_RECEIPT_ALLOWED", "A2"."DAYS_LATE_RECEIPT_ALLOWED" "DAYS_LATE_RECEIPT_ALLOWED", "A2"."RECEIPT_DAYS_EXCEPTION_CODE" "RECEIPT_DAYS_EXCEPTION_CODE", "A2"."INVOICE_CLOSE_TOLERANCE" "INVOICE_CLOSE_TOLERANCE", "A2"."RECEIVE_CLOSE_TOLERANCE" "RECEIVE_CLOSE_TOLERANCE", "A2"."SHIP_TO_ORGANIZATION_ID" "SHIP_TO_ORGANIZATION_ID", "A2"."SOURCE_SHIPMENT_ID
" "SOURCE_SHIPMENT_ID", "A2"."CLOSED_CODE" "CLOSED_CODE", "A2"."REQUEST_ID" "REQUEST_ID", "A2"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A2"."PROGRAM_ID" "PROGRAM_ID", "A2"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A2"."LAST_ACCEPT_DATE" "LAST_ACCEPT_DATE", "A2"."ENCUMBERED_FLAG" "ENCUMBERED_FLAG", "A2"."ENCUMBERED_DATE" "ENCUMBERED_DATE", "A2"."UNENCUMBERED_QUANTITY" "UNENCUMBERED_QUANTITY", "A2"."FOB_LOOKUP_CODE" "FOB_LOOKUP_CODE", "A2"."FREIGHT_TERMS_LOOKUP_CODE" "FREIGHT_TERMS_LOOKUP_CODE", "A2"."ESTIMATED_TAX_AMOUNT" "ESTIMATED_TAX_AMOUNT", "A2"."FROM_HEADER_ID" "FROM_HEADER_ID", "A2"."FROM_LINE_ID" "FROM_LINE_ID", "A2"."FROM_LINE_LOCATION_ID" "FROM_LINE_LOCATION_ID", "A2"."LEAD_TIME" "LEAD_TIME", "A2"."LEAD_TIME_UNIT" "LEAD_TIME_UNIT", "A2"."PRICE_DISCOUNT" "PRICE_DISCOUNT", "A2"."TERMS_ID" "TERMS_ID", "A2"."APPROVED_FLAG" "APPROVED_FLAG", "A2"."APPROVED_DATE" "APPROVED_DATE", "A2"."CLOSED_FLAG" "CLOSED_FLAG", "A2"."CANCELLED_BY" "CANCELLED_BY", "A2"."FIRM_STATUS_LOOKUP_CODE" "FIRM_STATUS_LOOKUP_CODE", "A2"."FIRM_DATE" "FIRM_DATE", "A2"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A2"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A2"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A2"."CREATION_DATE" "CREATION_DATE", "A2"."CREATED_BY" "CREATED_BY", "A2"."QUANTITY_RECEIVED" "QUANTITY_RECEIVED", "A2"."QUANTITY_ACCEPTED" "QUANTITY_ACCEPTED", "A2"."QUANTITY_REJECTED" "QUANTITY_REJECTED", "A2"."QUANTITY_BILLED" "QUANTITY_BILLED", "A2"."UNIT_MEAS_LOOKUP_CODE" "UNIT_MEAS_LOOKUP_CODE", "A2"."SHIP_VIA_LOOKUP_CODE" "SHIP_VIA_LOOKUP_CODE", "A2"."GLOBAL_ATTRIBUTE_CATEGORY" "GLOBAL_ATTRIBUTE_CATEGORY", "A2"."GLOBAL_ATTRIBUTE1" "GLOBAL_ATTRIBUTE1", "A2"."GLOBAL_ATTRIBUTE2" "GLOBAL_ATTRIBUTE2", "A2"."GLOBAL_ATTRIBUTE3" "GLOBAL_ATTRIBUTE3", "A2"."GLOBAL_ATTRIBUTE4" "GLOBAL_ATTRIBUTE4", "A2"."GLOBAL_ATTRIBUTE5" "GLOBAL_ATTRIBUTE5", "A2"."GLOBAL_ATTRIBUTE6" "GLOBAL_ATTRIBUTE6", "A2"."GLOBAL_ATTRIBUTE7" "GLOBAL_ATTRIBUTE7", "A2"."GLOBAL_ATTRIBUTE8" "GLOBAL_ATTRIBUTE8", "A2"."GLOBAL_ATTRIBUTE9" "GLOBAL_ATTRIBUTE9", "A2"."GLOBAL_ATTRIBUTE10" "GLOBAL_ATTRIBUTE10", "A2"."GLOBAL_ATTRIBUTE11" "GLOBAL_ATTRIBUTE11", "A2"."GLOBAL_ATTRIBUTE12" "GLOBAL_ATTRIBUTE12", "A2"."GLOBAL_ATTRIBUTE13" "GLOBAL_ATTRIBUTE13", "A2"."GLOBAL_ATTRIBUTE14" "GLOBAL_ATTRIBUTE14", "A2"."GLOBAL_ATTRIBUTE15" "GLOBAL_ATTRIBUTE15", "A2"."GLOBAL_ATTRIBUTE16" "GLOBAL_ATTRIBUTE16", "A2"."GLOBAL
_ATTRIBUTE17" "GLOBAL_ATTRIBUTE17", "A2"."GLOBAL_ATTRIBUTE18" "GLOBAL_ATTRIBUTE18", "A2"."GLOBAL_ATTRIBUTE19" "GLOBAL_ATTRIBUTE19", "A2"."GLOBAL_ATTRIBUTE20" "GLOBAL_ATTRIBUTE20", "A2"."QUANTITY_SHIPPED" "QUANTITY_SHIPPED", "A2"."COUNTRY_OF_ORIGIN_CODE" "COUNTRY_OF_ORIGIN_CODE", "A2"."TAX_USER_OVERRIDE_FLAG" "TAX_USER_OVERRIDE_FLAG", "A2"."MATCH_OPTION" "MATCH_OPTION", "A2"."TAX_CODE_ID" "TAX_CODE_ID", "A2"."CALCULATE_TAX_FLAG" "CALCULATE_TAX_FLAG", "A2"."CHANGE_PROMISED_DATE_REASON" "CHANGE_PROMISED_DATE_REASON", "A2"."NOTE_TO_RECEIVER" "NOTE_TO_RECEIVER", "A2"."SECONDARY_UNIT_OF_MEASURE" "SECONDARY_UNIT_OF_MEASURE", "A2"."SECONDARY_QUANTITY" "SECONDARY_QUANTITY", "A2"."PREFERRED_GRADE" "PREFERRED_GRADE", "A2"."SECONDARY_QUANTITY_RECEIVED" "SECONDARY_QUANTITY_RECEIVED", "A2"."SECONDARY_QUANTITY_ACCEPTED" "SECONDARY_QUANTITY_ACCEPTED", "A2"."SECONDARY_QUANTITY_REJECTED" "SECONDARY_QUANTITY_REJECTED", "A2"."SECONDARY_QUANTITY_CANCELLED" "SECONDARY_QUANTITY_CANCELLED", "A2"."VMI_FLAG" "VMI_FLAG", "A2"."RETROACTIVE_DATE" "RETROACTIVE_DATE", "A2"."SUPPLIER_ORDER_LINE_NUMBER" "SUPPLIER_ORDER_LINE_NUMBER", "A2"."AMOUNT" "AMOUNT", "A2"."AMOUNT_RECEIVED" "AMOUNT_RECEIVED", "A2"."AMOUNT_BILLED" "AMOUNT_BILLED", "A2"."AMOUNT_CANCELLED" "AMOUNT_CANCELLED", "A2"."AMOUNT_ACCEPTED" "AMOUNT_ACCEPTED", "A2"."AMOUNT_REJECTED" "AMOUNT_REJECTED", "A2"."DROP_SHIP_FLAG" "DROP_SHIP_FLAG", "A2"."SALES_ORDER_UPDATE_DATE" "SALES_ORDER_UPDATE_DATE", "A2"."SHIP_TO_LOCATION_ID" "SHIP_TO_LOCATION_ID", "A2"."SHIP_TO_LOCATION_NAME" "SHIP_TO_LOCATION_NAME", "A2"."SHIP_TO_ADDRESS_LINE1" "SHIP_TO_ADDRESS_LINE1", "A2"."SHIP_TO_ADDRESS_LINE2" "SHIP_TO_ADDRESS_LINE2", "A2"."SHIP_TO_ADDRESS_LINE3" "SHIP_TO_ADDRESS_LINE3", "A2"."SHIP_TO_ADDRESS_LINE4" "SHIP_TO_ADDRESS_LINE4", "A2"."SHIP_TO_ADDRESS_INFO" "SHIP_TO_ADDRESS_INFO", "A2"."SHIP_TO_COUNTRY" "SHIP_TO_COUNTRY", "A2"."IS_SHIPMENT_ONE_TIME_LOC" "IS_SHIPMENT_ONE_TIME_LOC", "A2"."ONE_TIME_ADDRESS_DETAILS" "ONE_TIME_ADDRESS_DETAILS", "A2"."DETAILS" "DETAILS", "A2"."SHIP_CONT_PHONE" "SHIP_CONT_PHONE", "A2"."SHIP_CONT_EMAIL" "SHIP_CONT_EMAIL", "A2"."ULTIMATE_DELIVER_CONT_PHONE" "ULTIMATE_DELIVER_CONT_PHONE", "A2"."ULTIMATE_DELIVER_CONT_EMAIL" "ULTIMATE_DELIVER_CONT_EMAIL", "A2"."SHIP_CONT_NAME" "SHIP_CONT_NAME", "A2"."ULTIMATE_DELIVER_CONT_NAME" "ULTIMATE_DELIVER_CONT_NAME", "A2"."SHIP_CUST_NAME" "SHIP_CUST_NAME", "A2"."SHIP_CUST_LOCATION" "SHIP_CUST_LOCATION", "A2"."ULTIMATE_DELIVER_CUST_NAME" "ULTIMATE_DELIVER_CUST_NAME", "A2"."ULTIMATE_DELIV
ER_CUST_LOCATION" "ULTIMATE_DELIVER_CUST_LOCATION", "A2"."SHIP_TO_CONTACT_FAX" "SHIP_TO_CONTACT_FAX", "A2"."ULTIMATE_DELIVER_TO_CONT_NAME" "ULTIMATE_DELIVER_TO_CONT_NAME", "A2"."ULTIMATE_DELIVER_TO_CONT_FAX" "ULTIMATE_DELIVER_TO_CONT_FAX", "A2"."SHIPPING_METHOD" "SHIPPING_METHOD", "A2"."SHIPPING_INSTRUCTIONS" "SHIPPING_INSTRUCTIONS", "A2"."PACKING_INSTRUCTIONS" "PACKING_INSTRUCTIONS", "A2"."CUSTOMER_PRODUCT_DESC" "CUSTOMER_PRODUCT_DESC", "A2"."CUSTOMER_PO_NUM" "CUSTOMER_PO_NUM", "A2"."CUSTOMER_PO_LINE_NUM" "CUSTOMER_PO_LINE_NUM", "A2"."CUSTOMER_PO_SHIPMENT_NUM" "CUSTOMER_PO_SHIPMENT_NUM", "A2"."NEED_BY_DATE" "NEED_BY_DATE", "A2"."PROMISED_DATE" "PROMISED_DATE", "A2"."TOTAL_SHIPMENT_AMOUNT" "TOTAL_SHIPMENT_AMOUNT", "A2"."FINAL_MATCH_FLAG" "FINAL_MATCH_FLAG", "A2"."MANUAL_PRICE_CHANGE_FLAG" "MANUAL_PRICE_CHANGE_FLAG", "A2"."TAX_NAME" "TAX_NAME", "A2"."TRANSACTION_FLOW_HEADER_ID" "TRANSACTION_FLOW_HEADER_ID", "A2"."VALUE_BASIS" "VALUE_BASIS", "A2"."MATCHING_BASIS" "MATCHING_BASIS", "A2"."PAYMENT_TYPE" "PAYMENT_TYPE", "A2"."DESCRIPTION" "DESCRIPTION", "A2"."QUANTITY_FINANCED" "QUANTITY_FINANCED", "A2"."AMOUNT_FINANCED" "AMOUNT_FINANCED", "A2"."QUANTITY_RECOUPED" "QUANTITY_RECOUPED", "A2"."AMOUNT_RECOUPED" "AMOUNT_RECOUPED", "A2"."RETAINAGE_WITHHELD_AMOUNT" "RETAINAGE_WITHHELD_AMOUNT", "A2"."RETAINAGE_RELEASED_AMOUNT" "RETAINAGE_RELEASED_AMOUNT", "A2"."WORK_APPROVER_ID" "WORK_APPROVER_ID", "A2"."BID_PAYMENT_ID" "BID_PAYMENT_ID", "A2"."AMOUNT_SHIPPED" "AMOUNT_SHIPPED", CURSOR (SELECT "A2"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A59"."SHORT_TEXT" "SHORT_TEXT" FROM "FND_ATTACHED_DOCS_FORM_VL" "A60", "APPLSYS"."FND_DOCUMENTS_SHORT_TEXT" "A59" WHERE "A60"."ENTITY_NAME"='PO_SHIPMENTS' AND "A60"."PK1_VALUE"=TO_CHAR("A2"."LINE_LOCATION_ID") AND "A60"."FUNCTION_NAME"='PO_PRINTPO' AND "A60"."MEDIA_ID"="A59"."MEDIA_ID" AND "A60"."DATATYPE_ID"=1 ORDER BY "A60"."SEQ_NUM") "LINE_LOC_SHORT_TEXT", CURSOR (SELECT "A58"."URL" "WEB_PAGE" FROM "FND_ATTACHED_DOCS_FORM_VL" "A58" WHERE "A58"."ENTITY_NAME"='PO_SHIPMENTS' AND "A58"."PK1_VALUE"=TO_CHAR("A2"."LINE_LOCATION_ID") AND "A58"."DATATYPE_ID"=5 AND "A58"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A58"."SEQ_NUM") "LINE_LOC_URL_ATTACHMENTS", CURSOR (SELECT "A57"."FILE_NAME" "FILE_NAME" FROM "FND_ATTACHED_DOCS_FORM_VL" "A57" WHERE "A57"."ENTITY_NAME"='PO_SHIPMENTS' AND "A57"."PK1_VALUE"=TO_CHAR("A2"."LINE_LOCATION_ID") AND "A57"."DATATYPE_ID"=6 AND "A57"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A57".
"SEQ_NUM") "LINE_LOC_FILE_ATTACHMENTS", CURSOR (SELECT "A56"."AMOUNT_ORDERED" "AMOUNT_ORDERED", "A56"."AMOUNT_DELIVERED" "AMOUNT_DELIVERED", "A56"."AMOUNT_CANCELLED" "AMOUNT_CANCELLED", "A56"."DISTRIBUTION_TYPE" "DISTRIBUTION_TYPE", "A56"."AMOUNT_TO_ENCUMBER" "AMOUNT_TO_ENCUMBER", "A56"."INVOICE_ADJUSTMENT_FLAG" "INVOICE_ADJUSTMENT_FLAG", "A56"."DEST_CHARGE_ACCOUNT_ID" "DEST_CHARGE_ACCOUNT_ID", "A56"."DEST_VARIANCE_ACCOUNT_ID" "DEST_VARIANCE_ACCOUNT_ID", "A56"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A56"."PROJECT_ID" "PROJECT_ID", "A56"."TASK_ID" "TASK_ID", "A56"."EXPENDITURE_TYPE" "EXPENDITURE_TYPE", "A56"."PROJECT_ACCOUNTING_CONTEXT" "PROJECT_ACCOUNTING_CONTEXT", "A56"."EXPENDITURE_ORGANIZATION_ID" "EXPENDITURE_ORGANIZATION_ID", "A56"."GL_CLOSED_DATE" "GL_CLOSED_DATE", "A56"."ACCRUE_ON_RECEIPT_FLAG" "ACCRUE_ON_RECEIPT_FLAG", "A56"."EXPENDITURE_ITEM_DATE" "EXPENDITURE_ITEM_DATE", "A56"."ORG_ID" "ORG_ID", "A56"."GL_ENCUMBERED_PERIOD_NAME" "GL_ENCUMBERED_PERIOD_NAME", "A56"."GL_CANCELLED_DATE" "GL_CANCELLED_DATE", "A56"."DESTINATION_TYPE_CODE" "DESTINATION_TYPE_CODE", "A56"."DESTINATION_ORGANIZATION_ID" "DESTINATION_ORGANIZATION_ID", "A56"."DESTINATION_SUBINVENTORY" "DESTINATION_SUBINVENTORY", "A56"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A56"."ATTRIBUTE1" "ATTRIBUTE1", "A56"."ATTRIBUTE2" "ATTRIBUTE2", "A56"."ATTRIBUTE3" "ATTRIBUTE3", "A56"."ATTRIBUTE4" "ATTRIBUTE4", "A56"."ATTRIBUTE5" "ATTRIBUTE5", "A56"."ATTRIBUTE6" "ATTRIBUTE6", "A56"."ATTRIBUTE7" "ATTRIBUTE7", "A56"."ATTRIBUTE8" "ATTRIBUTE8", "A56"."ATTRIBUTE9" "ATTRIBUTE9", "A56"."ATTRIBUTE10" "ATTRIBUTE10", "A56"."ATTRIBUTE11" "ATTRIBUTE11", "A56"."ATTRIBUTE12" "ATTRIBUTE12", "A56"."ATTRIBUTE13" "ATTRIBUTE13", "A56"."ATTRIBUTE14" "ATTRIBUTE14", "A56"."ATTRIBUTE15" "ATTRIBUTE15", "A56"."WIP_ENTITY_ID" "WIP_ENTITY_ID", "A56"."WIP_OPERATION_SEQ_NUM" "WIP_OPERATION_SEQ_NUM", "A56"."WIP_RESOURCE_SEQ_NUM" "WIP_RESOURCE_SEQ_NUM", "A56"."WIP_REPETITIVE_SCHEDULE_ID" "WIP_REPETITIVE_SCHEDULE_ID", "A56"."WIP_LINE_ID" "WIP_LINE_ID", "A56"."BOM_RESOURCE_ID" "BOM_RESOURCE_ID", "A56"."BUDGET_ACCOUNT_ID" "BUDGET_ACCOUNT_ID", "A56"."ACCRUAL_ACCOUNT_ID" "ACCRUAL_ACCOUNT_ID", "A56"."VARIANCE_ACCOUNT_ID" "VARIANCE_ACCOUNT_ID", "A56"."PREVENT_ENCUMBRANCE_FLAG" "PREVENT_ENCUMBRANCE_FLAG", "A56"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A56"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A56"."PO_DISTRIBUTION_ID" "PO_DISTRIBUTION_ID
", "A56"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A56"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A56"."PO_HEADER_ID" "PO_HEADER_ID", "A56"."PO_LINE_ID" "PO_LINE_ID", "A56"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A56"."SET_OF_BOOKS_ID" "SET_OF_BOOKS_ID", "A56"."CODE_COMBINATION_ID" "CODE_COMBINATION_ID", "A56"."QUANTITY_ORDERED" "QUANTITY_ORDERED", "A56"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A56"."CREATION_DATE" "CREATION_DATE", "A56"."CREATED_BY" "CREATED_BY", "A56"."PO_RELEASE_ID" "PO_RELEASE_ID", "A56"."QUANTITY_DELIVERED" "QUANTITY_DELIVERED", "A56"."QUANTITY_BILLED" "QUANTITY_BILLED", "A56"."QUANTITY_CANCELLED" "QUANTITY_CANCELLED", "A56"."REQ_HEADER_REFERENCE_NUM" "REQ_HEADER_REFERENCE_NUM", "A56"."REQ_LINE_REFERENCE_NUM" "REQ_LINE_REFERENCE_NUM", "A56"."REQ_DISTRIBUTION_ID" "REQ_DISTRIBUTION_ID", "A56"."DELIVER_TO_LOCATION_ID" "DELIVER_TO_LOCATION_ID", "A56"."DELIVER_TO_PERSON_ID" "DELIVER_TO_PERSON_ID", "A56"."RATE_DATE" "RATE_DATE", "A56"."RATE" "RATE", "A56"."AMOUNT_BILLED" "AMOUNT_BILLED", "A56"."ACCRUED_FLAG" "ACCRUED_FLAG", "A56"."ENCUMBERED_FLAG" "ENCUMBERED_FLAG", "A56"."ENCUMBERED_AMOUNT" "ENCUMBERED_AMOUNT", "A56"."UNENCUMBERED_QUANTITY" "UNENCUMBERED_QUANTITY", "A56"."UNENCUMBERED_AMOUNT" "UNENCUMBERED_AMOUNT", "A56"."FAILED_FUNDS_LOOKUP_CODE" "FAILED_FUNDS_LOOKUP_CODE", "A56"."GL_ENCUMBERED_DATE" "GL_ENCUMBERED_DATE", "A56"."KANBAN_CARD_ID" "KANBAN_CARD_ID", "A56"."END_ITEM_UNIT_NUMBER" "END_ITEM_UNIT_NUMBER", "A56"."AWARD_ID" "AWARD_ID", "A56"."MRC_RATE_DATE" "MRC_RATE_DATE", "A56"."MRC_RATE" "MRC_RATE", "A56"."MRC_ENCUMBERED_AMOUNT" "MRC_ENCUMBERED_AMOUNT", "A56"."MRC_UNENCUMBERED_AMOUNT" "MRC_UNENCUMBERED_AMOUNT", "A56"."RECOVERABLE_TAX" "RECOVERABLE_TAX", "A56"."NONRECOVERABLE_TAX" "NONRECOVERABLE_TAX", "A56"."RECOVERY_RATE" "RECOVERY_RATE", "A56"."TAX_RECOVERY_OVERRIDE_FLAG" "TAX_RECOVERY_OVERRIDE_FLAG", "A56"."OKE_CONTRACT_LINE_ID" "OKE_CONTRACT_LINE_ID", "A56"."OKE_CONTRACT_DELIVERABLE_ID" "OKE_CONTRACT_DELIVERABLE_ID", "A56"."DESTINATION_CONTEXT" "DESTINATION_CONTEXT", "A56"."DISTRIBUTION_NUM" "DISTRIBUTION_NUM", "A56"."SOURCE_DISTRIBUTION_ID" "SOURCE_DISTRIBUTION_ID", "A56"."REQUEST_ID" "REQUEST_ID", "A56"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A56"."PROGRAM_ID" "PROGRAM_ID", "A56"."CHARGE_ACCOUNT" "CHARGE_ACCOUNT", "A56"."FULL_NAME" "FULL_NAME", "A56"."WORK_TELEPHONE" "WORK_TELEPHONE", "A56"."EMAIL_ADDRESS" "EMAIL_ADDRESS",
"A56"."REQUESTER_DELIVER_FIRST_NAME" "REQUESTER_DELIVER_FIRST_NAME", "A56"."REQUESTER_DELIVER_LAST_NAME" "REQUESTER_DELIVER_LAST_NAME", "A56"."REQUESTER_DELIVER_TITLE" "REQUESTER_DELIVER_TITLE", "A56"."QUANTITY_FINANCED" "QUANTITY_FINANCED", "A56"."AMOUNT_FINANCED" "AMOUNT_FINANCED", "A56"."QUANTITY_RECOUPED" "QUANTITY_RECOUPED", "A56"."AMOUNT_RECOUPED" "AMOUNT_RECOUPED", "A56"."RETAINAGE_WITHHELD_AMOUNT" "RETAINAGE_WITHHELD_AMOUNT", "A56"."RETAINAGE_RELEASED_AMOUNT" "RETAINAGE_RELEASED_AMOUNT" FROM "PO_DISTRIBUTION_XML" "A56" WHERE "A56"."PO_HEADER_ID"=:CV1$$ AND "A56"."LINE_LOCATION_ID"="A2"."LINE_LOCATION_ID") "DISTRIBUTIONS" FROM "PO_LINE_LOCATIONS_XML" "A2" WHERE "A2"."PO_LINE_ID"=:CV1$ AND NVL("A2"."PAYMENT_TYPE", 'NONE')<>'ADVANCE' AND NVL("A2"."PAYMENT_TYPE", 'NONE')<>'DELIVERY' |
| 4z510cva9wzsv |
SELECT decode ( : P_sortby , 'PO NUMBER' , null , poh . document_buyer_last_name ) , decode ( : P_sortby , 'PO NUMBER' , null , poh . document_buyer_first_name ) , decode ( : po_num_type , 'NUMERIC' , null , poh . po_num ) , decode ( : po_num_type , 'NUMERIC' , decode ( rtrim ( poh . po_num , '0123456789' ) , NULL , to_number ( poh . po_num ) , - 1 ) , null ) , poh . po_type poh_po_type , por . release_type poh_release_type , poh . po_num || decode ( poh . po_type , 'RELEASE' , '-' || por . release_num , null ) poh_po_num , poh . po_num security_poh_po_num , por . release_num security_por_po_num , poh . revision_num poh_revision_num , poh . vendor_name poh_vendor_name , poh . vendor_address_line1 poh_vendor_address_line1 , poh . vendor_address_line2 poh_vendor_address_line2 , poh . vendor_address_line3 poh_vendor_address_line3 , decode ( poh . vendor_city , null , poh . vendor_state || ' ' || poh . vendor_postal_code , poh . vendor_city || ', ' || poh . vendor_state || ' ' || poh . vendor_postal_code ) poh_vendor_adr_info , poh . vendor_country poh_vendor_country , poh . customer_num poh_customer , poh . vendor_num poh_vendor_num , poh . creation_date poh_creation_date , poh . revised_date poh_revised_date , substr ( substr ( poh . document_buyer_first_name , 1 , 1 ) || ' ' || poh . document_buyer_last_name , 1 , 12 ) poh_buyer , substr ( trim ( substr ( poh . archive_buyer_first_name , 1 , 1 ) || ' ' || poh . archive_buyer_last_name ) , 1 , 12 ) poh_archive_buyer , poh . document_buyer_agent_id poh_agent_id , poh . payment_terms poh_payment_terms , poh . ship_via poh_ship_via , poh . fob poh_fob , poh . freight_terms poh_freight_terms , substr ( poh . vendor_contact_first_name , 1 , 1 ) || ' ' || substr ( poh . vendor_contact_last_name , 1 , 10 ) poh_vendor_contact_name , poh . vendor_phone poh_vendor_phone , poh . vendor_contact_phone poh_vendor_contact_phone , poh . note_to_vendor poh_note_to_vendor , poh . printed_date poh_printed_date , poh . amount_agreed poh_amount_agreed , poh . cancel_flag poh_cancel_flag , poh . confirming_order_flag poh_confirming_order_flag , poh . acceptance_required_flag poh_acceptance_req_flag , poh . acceptance_due_date poh_acceptance_due_date , poh . currency_code poh_currency_code , poh . currency_code C_CURRENCY , poh . currency_name poh_currency_name , poh . currency_conversion_rate poh_currency_conversion_rate , poh . bill_to_location_id poh_bill_to_location , poh . ship_to_location_id poh_ship_to_location , poh . po_header_id poh_po_header_id , poh . po_release_id poh_po_release_id , poh . po_type poh_po_type , poh . approved_flag poh_approved_flag , poh . print_count poh_print_count , poh . effective_date poh_effective_date , poh . expiration_date poh_expiration_date , nvl ( poh . po_release_id , - 1 ) poh_join_release_id , poh . vendor_site_id poh_vendor_site_id , poh . vendor_id poh_vendor_id FROM po_headers_print poh , po_releases por WHERE poh . po_release_id = por . po_release_id (+) AND ( nvl ( por . release_num , - 1 ) BETWEEN nvl ( : P_release_num_from , nvl ( por . release_num , - 1 ) ) AND nvl ( : P_release_num_to , nvl ( por . release_num , - 1 ) ) OR poh . po_type != 'RELEASE' ) AND poh . document_buyer_agent_id = nvl ( : P_agent_id , poh . document_buyer_agent_id ) AND ( poh . release_date is NULL OR trunc ( poh . release_date ) BETWEEN nvl ( : P_date_from , trunc ( poh . release_date ) ) AND nvl ( : P_date_to , trunc ( poh . release_date ) + 1 ) ) AND nvl ( poh . approved_flag , 'N' ) = nvl ( : P_approved_flag , nvl ( poh . approved_flag , 'N' ) ) AND ( ( nvl ( : P_print_releases , 'Y' ) = 'Y' ) or ( nvl ( : P_print_releases , 'Y' ) = 'N' and poh . po_type != 'RELEASE' ) ) AND nvl ( poh . consigned_consumption_flag , 'N' ) <> 'Y' AND nvl ( por . consigned_consumption_flag , 'N' ) <> 'Y' AND :P_single_po_print = 1 AND po_num = :P_po_num_from AND nvl(poh.print_
count, 0) = 0 AND NOT EXISTS (SELECT 'X' from ECE_TP_DETAILS ETD, ECE_TP_HEADERS ETH, PO_VENDOR_SITES E_PVS WHERE E_PVS.VENDOR_SITE_ID = POH.VENDOR_SITE_ID AND ETH.TP_HEADER_ID = E_PVS.TP_HEADER_ID AND ETD.TP_HEADER_ID = ETH.TP_HEADER_ID AND ETD.EDI_FLAG = 'Y' AND ETD.DOCUMENT_ID = 'POO' AND ETD.DOCUMENT_TYPE = POH.PO_TYPE ) and 1=1 ORDER BY 1 , 2 , 3 , 4 |
| 51bbkcd9zwsjw | /* OracleOEM */ with max1 as (select :1 as select_tab, :2 as select_priv from dual) select 'select_any_table', substr(SYS_CONNECT_BY_PATH(c, '->'), 3, 512) path, c from ( select null p, name c from system_privilege_map where name = 'SELECT ANY TABLE' union select granted_role p, grantee c from dba_role_privs union select privilege p, grantee c from dba_sys_privs ) where ((c = 'PUBLIC') or (exists (select 'w' from dba_users where username=c))) and rownum <= decode((select select_tab from max1), '-1', 2147483647, (select select_tab from max1)) start with p is null connect by p = prior c union select 'select_privilege', substr(SYS_CONNECT_BY_PATH(c, '->'), 3, 512) path, c from ( select null p, view_name c from dba_views where view_name like 'DBA_%' union select granted_role p, grantee c from dba_role_privs union select table_name p, grantee c from dba_tab_privs where privilege = 'SELECT' ) where ((c = 'PUBLIC') or (exists (select 'w' from dba_users where username=c))) and rownum <= decode((select select_priv from max1), '-1', 2147483647, (select select_priv from max1)) start with p is null connect by p = prior c |
| 529wb67xu0sy9 | SELECT INPUT_TAX_CLASSIFICATION_CODE FROM ZX_LINES_DET_FACTORS WHERE APPLICATION_ID = :B6 AND ENTITY_CODE = :B5 AND EVENT_CLASS_CODE = :B4 AND TRX_ID = :B3 AND TRX_LINE_ID = :B2 AND TRX_LEVEL_TYPE = :B1 |
| 54tzhmhcs8nkh |
declare context DBMS_XMLGEN.ctxHandle; l_xml_query varchar2(15000) ; l_headerAttach_query varchar2(1000); l_lineAttach_query varchar2(1200) ; --Bug5213932 increase length l_disAttach_query varchar2(1200) ; --Bug5213932 increase length l_time varchar2(50); g_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_COMMUNICATION_PVT.'; l_api_name CONSTANT VARCHAR2(30):= 'POXMLGEN'; TYPE ref_cursorType IS REF CURSOR; refcur ref_cursorType; l_fileClob CLOB := NULL; Begin l_xml_query := :1 ; l_headerAttach_query := :2; l_lineAttach_query := :3; l_disAttach_query := :4; l_fileClob := :5; select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Before Executing the Main Query', l_time); END IF; context := dbms_xmlgen.newContext(l_xml_query); dbms_xmlgen.setRowsetTag(context, 'PO_DATA'); dbms_xmlgen.setRowTag(context, NULL); dbms_xmlgen.setConvertSpecialChars ( context, TRUE); :xresult := dbms_xmlgen.getXML(context, DBMS_XMLGEN.NONE); dbms_xmlgen.closeContext(context); select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'After Executing the Main Query', l_time); END IF; context := dbms_xmlgen.newContext(l_headerAttach_query); dbms_xmlgen.setRowsetTag(context, 'HEADER_ATTACHMENTS'); dbms_xmlgen.setRowTag(context, NULL); dbms_xmlgen.setConvertSpecialChars ( context, TRUE); :xheaderAttach := dbms_xmlgen.getXML(context, DBMS_XMLGEN.NONE); dbms_xmlgen.closeContext(context); select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'After Executing the header attachment Query', l_time); END IF; context := dbms_xmlgen.newContext(l_lineAttach_query); dbms_xmlgen.setRowsetTag(context, 'LINE_ATTACHMENTS'); dbms_xmlgen.setRowTag(context, NULL); dbms_xmlgen.setConvertSpecialChars ( context, TRUE); :xlineAttach := dbms_xmlgen.getXML(context, DBMS_XMLGEN.NONE); dbms_xmlgen.closeContext(context); select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'After Executing the line attachment Query', l_time); END IF; context := dbms_xmlgen.newContext(l_disAttach_query); dbms_xmlgen.setRowsetTag(context, 'SHIPMENT_ATTACHMENTS'); dbms_xmlgen.setRowTag(context, NULL); dbms_xmlgen.setConvertSpecialChars ( context, TRUE); :xdisAttach := dbms_xmlgen.getXML(context, DBMS_XMLGEN.NONE); dbms_xmlgen.closeContext(context); select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'After Executing the shipment attachment Query', l_time); END IF; IF l_fileClob is not null THEN open refcur for 'select :l_fileClob1 as text_file from dual' using l_fileClob; context := DBMS_XMLGEN.newContext(refcur); DBMS_XMLGEN.setRowTag(context, NULL); DBMS_XMLGEN.setRowSetTag(context, NULL); :xfileClob := DBMS_XMLGEN.getXML(context, DBMS_XMLGEN.NONE); DBMS_XMLGEN.closeContext(context); close refcur; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , 'After executing the file clob'); END IF; ELSE IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , 'Value of File clob is null'); END IF; :xfileClob := null; END IF; -- bug#3580225 Start -- select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVE
L <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Before calling PO_HR_LOCATION.populate_gt', l_time); END IF; /* Call PO_HR_LOCATION.populate_gt procedure to insert address values into global temp table from PL/SQL table*/ PO_HR_LOCATION.populate_gt(); BEGIN context := dbms_xmlgen.newContext('select * from po_address_details_gt '); dbms_xmlgen.setRowsetTag(context, 'ADDRESS_DETAILS'); dbms_xmlgen.setRowTag(context, 'ADDRESS_DETAILS_ROW'); :xaddrDetails := dbms_xmlgen.getXML(context, DBMS_XMLGEN.NONE); dbms_xmlgen.closeContext(context); EXCEPTION WHEN OTHERS THEN NULL; END; -- bug#3580225 Start -- End; |
| 54wkgprhc32fh | SELECT COUNT(*), DATA_TYPE FROM SYS.DBA_TAB_COLS WHERE DATA_TYPE IN ('ORDIMAGE', 'ORDAUDIO', 'ORDDOC', 'ORDVIDEO', 'SI_COLOR', 'SI_STILLIMAGE', 'SI_AVERAGECOLOR', 'SI_COLORHISTOGRAM', 'SI_POSITIONALCOLOR', 'SI_TEXTURE', 'SI_FEATURELIST') AND OWNER != 'PM' GROUP BY DATA_TYPE |
| 5vbbcp6pd58b8 | begin Fnd_Concurrent.Init_Request; end; |
| 6129566gyvx21 | SELECT INSTANTIABLE, supertype_owner, supertype_name, LOCAL_ATTRIBUTES FROM all_types WHERE type_name = :1 AND owner = :2 |
| 67mmmbx5hb3p0 | BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, true);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;:21 := fnd_session_management.g_proxy_user_id; :22 := fnd_session_management.g_mode_code; END; |
| 6vx0fw5141z4n | SELECT STATUS_FLAG FROM IGI_GCC_INSTALLED_OPTIONS WHERE OPTION_NAME = UPPER(:B1 ) |
| 7qs7fx89194u1 | SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL |
| 7yr8xbwxpdnav | INSERT INTO WIP_EAM_DIRECT_ITEMS ( DESCRIPTION , PURCHASING_CATEGORY_ID , DIRECT_ITEM_SEQUENCE_ID , OPERATION_SEQ_NUM , DEPARTMENT_ID , WIP_ENTITY_ID , ORGANIZATION_ID , SUGGESTED_VENDOR_NAME , SUGGESTED_VENDOR_ID , SUGGESTED_VENDOR_SITE , SUGGESTED_VENDOR_SITE_ID , SUGGESTED_VENDOR_CONTACT , SUGGESTED_VENDOR_CONTACT_ID , UNIT_PRICE , AUTO_REQUEST_MATERIAL , REQUIRED_QUANTITY , UOM , NEED_BY_DATE , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , ORDER_TYPE_LOOKUP_CODE) VALUES ( :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , 'Y' , :B4 , :B3 , :B2 , SYSDATE , FND_GLOBAL.USER_ID , SYSDATE , FND_GLOBAL.USER_ID , FND_GLOBAL.LOGIN_ID , :B1 ) |
| 81xv2tma4cag8 |
SELECT "A2"."ITEM_REVISION" "ITEM_REVISION", "A2"."LINE_NUM" "LINE_NUM", "A2"."ITEM_DESCRIPTION" "ITEM_DESCRIPTION", "A2"."CANCEL_FLAG" "CANCEL_FLAG", "A2"."CANCEL_DATE" "CANCEL_DATE", "A2"."CANCEL_REASON" "CANCEL_REASON", "A2"."VENDOR_PRODUCT_NUM" "VENDOR_PRODUCT_NUM", "A2"."NOTE_TO_VENDOR" "NOTE_TO_VENDOR", "A2"."UNIT_MEAS_LOOKUP_CODE" "UNIT_MEAS_LOOKUP_CODE", "A2"."UN_NUMBER" "UN_NUMBER", "A2"."UN_DESC" "UN_DESC", "A2"."HAZARD_CLASS" "HAZARD_CLASS", "A2"."ORDER_TYPE_LOOKUP_CODE" "ORDER_TYPE_LOOKUP_CODE", "A2"."CONTRACT_NUM" "CONTRACT_NUM", "A2"."SEGMENT1" "SEGMENT1", "A2"."GLOBAL_AGREEMENT_FLAG" "GLOBAL_AGREEMENT_FLAG", "A2"."QUOTE_VENDOR_QUOTE_NUMBER" "QUOTE_VENDOR_QUOTE_NUMBER", "A2"."QUOTATION_LINE" "QUOTATION_LINE", "A2"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A2"."ATTRIBUTE1" "ATTRIBUTE1", "A2"."ATTRIBUTE2" "ATTRIBUTE2", "A2"."ATTRIBUTE3" "ATTRIBUTE3", "A2"."ATTRIBUTE4" "ATTRIBUTE4", "A2"."ATTRIBUTE5" "ATTRIBUTE5", "A2"."ATTRIBUTE6" "ATTRIBUTE6", "A2"."ATTRIBUTE7" "ATTRIBUTE7", "A2"."ATTRIBUTE8" "ATTRIBUTE8", "A2"."ATTRIBUTE9" "ATTRIBUTE9", "A2"."ATTRIBUTE10" "ATTRIBUTE10", "A2"."ATTRIBUTE11" "ATTRIBUTE11", "A2"."ATTRIBUTE12" "ATTRIBUTE12", "A2"."ATTRIBUTE13" "ATTRIBUTE13", "A2"."ATTRIBUTE14" "ATTRIBUTE14", "A2"."ATTRIBUTE15" "ATTRIBUTE15", "A2"."UNIT_PRICE" "UNIT_PRICE", "A2"."QUANTITY" "QUANTITY", "A2"."QUANTITY_COMMITTED" "QUANTITY_COMMITTED", "A2"."PO_HEADER_ID" "PO_HEADER_ID", "A2"."PO_LINE_ID" "PO_LINE_ID", "A2"."ITEM_ID" "ITEM_ID", "A2"."FROM_HEADER_ID" "FROM_HEADER_ID", "A2"."FROM_LINE_ID" "FROM_LINE_ID", "A2"."REFERENCE_NUM" "REFERENCE_NUM", "A2"."MIN_RELEASE_AMOUNT" "MIN_RELEASE_AMOUNT", "A2"."PRICE_TYPE_LOOKUP_CODE" "PRICE_TYPE_LOOKUP_CODE", "A2"."CLOSED_CODE" "CLOSED_CODE", "A2"."PRICE_BREAK_LOOKUP_CODE" "PRICE_BREAK_LOOKUP_CODE", "A2"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A2"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A2"."REQUEST_ID" "REQUEST_ID", "A2"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A2"."PROGRAM_ID" "PROGRAM_ID", "A2"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A2"."CLOSED_DATE" "CLOSED_DATE", "A2"."CLOSED_REASON" "CLOSED_REASON", "A2"."CLOSED_BY" "CLOSED_BY", "A2"."TRANSACTION_REASON_CODE" "TRANSACTION_REASON_CODE", "A2"."ORG_ID" "ORG_ID", "A2".
"HAZARD_CLASS_ID" "HAZARD_CLASS_ID", "A2"."MIN_ORDER_QUANTITY" "MIN_ORDER_QUANTITY", "A2"."MAX_ORDER_QUANTITY" "MAX_ORDER_QUANTITY", "A2"."QTY_RCV_TOLERANCE" "QTY_RCV_TOLERANCE", "A2"."OVER_TOLERANCE_ERROR_FLAG" "OVER_TOLERANCE_ERROR_FLAG", "A2"."MARKET_PRICE" "MARKET_PRICE", "A2"."UNORDERED_FLAG" "UNORDERED_FLAG", "A2"."CLOSED_FLAG" "CLOSED_FLAG", "A2"."USER_HOLD_FLAG" "USER_HOLD_FLAG", "A2"."CANCELLED_BY" "CANCELLED_BY", "A2"."FIRM_STATUS_LOOKUP_CODE" "FIRM_STATUS_LOOKUP_CODE", "A2"."FIRM_DATE" "FIRM_DATE", "A2"."TAXABLE_FLAG" "TAXABLE_FLAG", "A2"."TYPE_1099" "TYPE_1099", "A2"."CAPITAL_EXPENSE_FLAG" "CAPITAL_EXPENSE_FLAG", "A2"."NEGOTIATED_BY_PREPARER_FLAG" "NEGOTIATED_BY_PREPARER_FLAG", "A2"."QC_GRADE" "QC_GRADE", "A2"."BASE_UOM" "BASE_UOM", "A2"."BASE_QTY" "BASE_QTY", "A2"."SECONDARY_UOM" "SECONDARY_UOM", "A2"."SECONDARY_QTY" "SECONDARY_QTY", "A2"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A2"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A2"."LINE_TYPE_ID" "LINE_TYPE_ID", "A2"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A2"."CREATION_DATE" "CREATION_DATE", "A2"."CREATED_BY" "CREATED_BY", "A2"."CATEGORY_ID" "CATEGORY_ID", "A2"."COMMITTED_AMOUNT" "COMMITTED_AMOUNT", "A2"."ALLOW_PRICE_OVERRIDE_FLAG" "ALLOW_PRICE_OVERRIDE_FLAG", "A2"."NOT_TO_EXCEED_PRICE" "NOT_TO_EXCEED_PRICE", "A2"."LIST_PRICE_PER_UNIT" "LIST_PRICE_PER_UNIT", "A2"."UN_NUMBER_ID" "UN_NUMBER_ID", "A2"."GLOBAL_ATTRIBUTE_CATEGORY" "GLOBAL_ATTRIBUTE_CATEGORY", "A2"."GLOBAL_ATTRIBUTE1" "GLOBAL_ATTRIBUTE1", "A2"."GLOBAL_ATTRIBUTE2" "GLOBAL_ATTRIBUTE2", "A2"."GLOBAL_ATTRIBUTE3" "GLOBAL_ATTRIBUTE3", "A2"."GLOBAL_ATTRIBUTE4" "GLOBAL_ATTRIBUTE4", "A2"."GLOBAL_ATTRIBUTE5" "GLOBAL_ATTRIBUTE5", "A2"."GLOBAL_ATTRIBUTE6" "GLOBAL_ATTRIBUTE6", "A2"."GLOBAL_ATTRIBUTE7" "GLOBAL_ATTRIBUTE7", "A2"."GLOBAL_ATTRIBUTE8" "GLOBAL_ATTRIBUTE8", "A2"."GLOBAL_ATTRIBUTE9" "GLOBAL_ATTRIBUTE9", "A2"."GLOBAL_ATTRIBUTE10" "GLOBAL_ATTRIBUTE10", "A2"."GLOBAL_ATTRIBUTE11" "GLOBAL_ATTRIBUTE11", "A2"."GLOBAL_ATTRIBUTE12" "GLOBAL_ATTRIBUTE12", "A2"."GLOBAL_ATTRIBUTE13" "GLOBAL_ATTRIBUTE13", "A2"."GLOBAL_ATTRIBUTE14" "GLOBAL_ATTRIBUTE14", "A2"."GLOBAL_ATTRIBUTE15" "GLOBAL_ATTRIBUTE15", "A2"."GLOBAL_ATTRIBUTE16" "GLOBAL_ATTRIBUTE16", "A2"."GLOBAL_ATTRIBUTE17" "GLOBAL_ATTRIBUTE17", "A2"."GLOBAL_ATTRIBUTE18" "GLOBAL_ATTRIBUTE18", "A2"."GLOBAL_ATTRIBUTE19" "GLOBAL_ATTRIBUTE19", "A2"."GLOBAL_ATTRIBUTE20" "GLOBAL_ATTRIBUTE20", "A2
"."LINE_REFERENCE_NUM" "LINE_REFERENCE_NUM", "A2"."PROJECT_ID" "PROJECT_ID", "A2"."TASK_ID" "TASK_ID", "A2"."EXPIRATION_DATE" "EXPIRATION_DATE", "A2"."TAX_CODE_ID" "TAX_CODE_ID", "A2"."OKE_CONTRACT_HEADER_ID" "OKE_CONTRACT_HEADER_ID", "A2"."OKE_CONTRACT_VERSION_ID" "OKE_CONTRACT_VERSION_ID", "A2"."TAX_NAME" "TAX_NAME", "A2"."SECONDARY_UNIT_OF_MEASURE" "SECONDARY_UNIT_OF_MEASURE", "A2"."SECONDARY_QUANTITY" "SECONDARY_QUANTITY", "A2"."PREFERRED_GRADE" "PREFERRED_GRADE", "A2"."AUCTION_HEADER_ID" "AUCTION_HEADER_ID", "A2"."AUCTION_DISPLAY_NUMBER" "AUCTION_DISPLAY_NUMBER", "A2"."AUCTION_LINE_NUMBER" "AUCTION_LINE_NUMBER", "A2"."BID_NUMBER" "BID_NUMBER", "A2"."BID_LINE_NUMBER" "BID_LINE_NUMBER", "A2"."RETROACTIVE_DATE" "RETROACTIVE_DATE", "A2"."SUPPLIER_REF_NUMBER" "SUPPLIER_REF_NUMBER", "A2"."CONTRACT_ID" "CONTRACT_ID", "A2"."JOB_ID" "JOB_ID", "A2"."AMOUNT" "AMOUNT", "A2"."START_DATE" "START_DATE", "A2"."LINE_TYPE" "LINE_TYPE", "A2"."PURCHASE_BASIS" "PURCHASE_BASIS", "A2"."ITEM_NUM" "ITEM_NUM", "A2"."JOB_NAME" "JOB_NAME", "A2"."CONTRACTOR_FIRST_NAME" "CONTRACTOR_FIRST_NAME", "A2"."CONTRACTOR_LAST_NAME" "CONTRACTOR_LAST_NAME", "A2"."LINE_AMOUNT" "LINE_AMOUNT", "A2"."CANCELED_AMOUNT" "CANCELED_AMOUNT", "A2"."TOTAL_LINE_AMOUNT" "TOTAL_LINE_AMOUNT", "A2"."BASE_UNIT_PRICE" "BASE_UNIT_PRICE", "A2"."MANUAL_PRICE_CHANGE_FLAG" "MANUAL_PRICE_CHANGE_FLAG", "A2"."MATCHING_BASIS" "MATCHING_BASIS", "A2"."SVC_AMOUNT_NOTIF_SENT" "SVC_AMOUNT_NOTIF_SENT", "A2"."SVC_COMPLETION_NOTIF_SENT" "SVC_COMPLETION_NOTIF_SENT", "A2"."FROM_LINE_LOCATION_ID" "FROM_LINE_LOCATION_ID", "A2"."RETAINAGE_RATE" "RETAINAGE_RATE", "A2"."MAX_RETAINAGE_AMOUNT" "MAX_RETAINAGE_AMOUNT", "A2"."PROGRESS_PAYMENT_RATE" "PROGRESS_PAYMENT_RATE", "A2"."RECOUPMENT_RATE" "RECOUPMENT_RATE", CURSOR (SELECT "A40"."PRICE_TYPE_DSP" "PRICE_TYPE", "A40"."MULTIPLIER" "MULTIPLIER" FROM "PO_PRICE_DIFFERENTIALS_V" "A40" WHERE "A40"."ENTITY_TYPE"='PO LINE' AND "A40"."ENTITY_ID"="A2"."PO_LINE_ID" AND "A40"."ENABLED_FLAG"='Y') "PRICE_DIFF", CURSOR (SELECT "A2"."PO_LINE_ID" "PO_LINE_ID", "A38"."SHORT_TEXT" "SHORT_TEXT" FROM "FND_ATTACHED_DOCS_FORM_VL" "A39", "APPLSYS"."FND_DOCUMENTS_SHORT_TEXT" "A38" WHERE ("A39"."ENTITY_NAME"='PO_LINES' AND "A39"."PK1_VALUE"=TO_CHAR("A2"."PO_LINE_ID") OR "A39"."ENTITY_NAME"='MTL_SYSTEM_ITEMS' AND "A39"."PK1_VALUE"=TO_CHAR("APPS"."PO_COMMUNICATION_PVT"."GETINVENTORYORG
ID"()) AND "A39"."PK2_VALUE"=TO_CHAR("A2"."ITEM_ID") AND "A2"."ITEM_ID" IS NOT NULL OR "A39"."ENTITY_NAME"='PO_HEADERS' AND "A39"."PK1_VALUE"=TO_CHAR("A2"."FROM_HEADER_ID") AND "A2"."FROM_HEADER_ID" IS NOT NULL OR "A39"."ENTITY_NAME"='PO_IN_GA_LINES' AND "A39"."PK1_VALUE"=TO_CHAR("A2"."FROM_LINE_ID") AND "A2"."FROM_LINE_ID" IS NOT NULL OR "A39"."ENTITY_NAME"='PO_HEADERS' AND "A39"."PK1_VALUE"=TO_CHAR("A2"."CONTRACT_ID") AND "A2"."CONTRACT_ID" IS NOT NULL) AND "A39"."FUNCTION_NAME"='PO_PRINTPO' AND "A39"."MEDIA_ID"="A38"."MEDIA_ID" AND "A39"."DATATYPE_ID"=1 ORDER BY "A39"."SEQ_NUM") "LINE_SHORT_TEXT", CURSOR (SELECT "A37"."PRICE_ADJUSTMENT_ID" "PRICE_ADJUSTMENT_ID", "A37"."CREATION_DATE" "CREATION_DATE", "A37"."CREATED_BY" "CREATED_BY", "A37"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A37"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A37"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A37"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A37"."PROGRAM_ID" "PROGRAM_ID", "A37"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A37"."REQUEST_ID" "REQUEST_ID", "A37"."PO_HEADER_ID" "PO_HEADER_ID", "A37"."AUTOMATIC_FLAG" "AUTOMATIC_FLAG", "A37"."PO_LINE_ID" "PO_LINE_ID", "A37"."ADJ_LINE_NUM" "ADJ_LINE_NUM", "A37"."CONTEXT" "CONTEXT", "A37"."ATTRIBUTE1" "ATTRIBUTE1", "A37"."ATTRIBUTE2" "ATTRIBUTE2", "A37"."ATTRIBUTE3" "ATTRIBUTE3", "A37"."ATTRIBUTE4" "ATTRIBUTE4", "A37"."ATTRIBUTE5" "ATTRIBUTE5", "A37"."ATTRIBUTE6" "ATTRIBUTE6", "A37"."ATTRIBUTE7" "ATTRIBUTE7", "A37"."ATTRIBUTE8" "ATTRIBUTE8", "A37"."ATTRIBUTE9" "ATTRIBUTE9", "A37"."ATTRIBUTE10" "ATTRIBUTE10", "A37"."ATTRIBUTE11" "ATTRIBUTE11", "A37"."ATTRIBUTE12" "ATTRIBUTE12", "A37"."ATTRIBUTE13" "ATTRIBUTE13", "A37"."ATTRIBUTE14" "ATTRIBUTE14", "A37"."ATTRIBUTE15" "ATTRIBUTE15", "A37"."ORIG_SYS_DISCOUNT_REF" "ORIG_SYS_DISCOUNT_REF", "A37"."CHANGE_SEQUENCE" "CHANGE_SEQUENCE", "A37"."LIST_HEADER_ID" "LIST_HEADER_ID", "A37"."LIST_TYPE_CODE" "LIST_TYPE_CODE", "A37"."LIST_LINE_ID" "LIST_LINE_ID", "A37"."MODIFIER_DESC" "MODIFIER_DESC", "A37"."LIST_LINE_TYPE_CODE" "LIST_LINE_TYPE_CODE", "A37"."MODIFIER_LINE_TYPE" "MODIFIER_LINE_TYPE", "A37"."MODIFIED_FROM" "MODIFIED_FROM", "A37"."MODIFIED_TO" "MODIFIED_TO", "A37"."UPDATE_ALLOWED" "UPDATE_ALLOWED", "A37"."CHANGE_REASON_CODE" "CHANGE_REASON_CODE", "A37"."CHANGE_REASON_TEXT" "CHANGE_REASON_T
EXT", "A37"."UPDATED_FLAG" "UPDATED_FLAG", "A37"."APPLIED_FLAG" "APPLIED_FLAG", "A37"."OPERAND" "OPERAND", "A37"."ARITHMETIC_OPERATOR" "ARITHMETIC_OPERATOR", "A37"."COST_ID" "COST_ID", "A37"."TAX_CODE" "TAX_CODE", "A37"."TAX_EXEMPT_FLAG" "TAX_EXEMPT_FLAG", "A37"."TAX_EXEMPT_NUMBER" "TAX_EXEMPT_NUMBER", "A37"."TAX_EXEMPT_REASON_CODE" "TAX_EXEMPT_REASON_CODE", "A37"."PARENT_ADJUSTMENT_ID" "PARENT_ADJUSTMENT_ID", "A37"."INVOICED_FLAG" "INVOICED_FLAG", "A37"."ESTIMATED_FLAG" "ESTIMATED_FLAG", "A37"."INC_IN_SALES_PERFORMANCE" "INC_IN_SALES_PERFORMANCE", "A37"."ADJUSTED_AMOUNT" "ADJUSTED_AMOUNT", "A37"."PRICING_PHASE_ID" "PRICING_PHASE_ID", "A37"."CHARGE_TYPE_CODE" "CHARGE_TYPE_CODE", "A37"."CHARGE_SUBTYPE_CODE" "CHARGE_SUBTYPE_CODE", "A37"."RANGE_BREAK_QUANTITY" "RANGE_BREAK_QUANTITY", "A37"."ACCRUAL_CONVERSION_RATE" "ACCRUAL_CONVERSION_RATE", "A37"."PRICING_GROUP_SEQUENCE" "PRICING_GROUP_SEQUENCE", "A37"."ACCRUAL_FLAG" "ACCRUAL_FLAG", "A37"."LIST_LINE_NO" "LIST_LINE_NO", "A37"."SOURCE_SYSTEM_CODE" "SOURCE_SYSTEM_CODE", "A37"."BENEFIT_QTY" "BENEFIT_QTY", "A37"."BENEFIT_UOM_CODE" "BENEFIT_UOM_CODE", "A37"."PRINT_ON_INVOICE_FLAG" "PRINT_ON_INVOICE_FLAG", "A37"."EXPIRATION_DATE" "EXPIRATION_DATE", "A37"."REBATE_TRANSACTION_TYPE_CODE" "REBATE_TRANSACTION_TYPE_CODE", "A37"."REBATE_TRANSACTION_REFERENCE" "REBATE_TRANSACTION_REFERENCE", "A37"."REBATE_PAYMENT_SYSTEM_CODE" "REBATE_PAYMENT_SYSTEM_CODE", "A37"."REDEEMED_DATE" "REDEEMED_DATE", "A37"."REDEEMED_FLAG" "REDEEMED_FLAG", "A37"."MODIFIER_LEVEL_CODE" "MODIFIER_LEVEL_CODE", "A37"."PRICE_BREAK_TYPE_CODE" "PRICE_BREAK_TYPE_CODE", "A37"."SUBSTITUTION_ATTRIBUTE" "SUBSTITUTION_ATTRIBUTE", "A37"."PRORATION_TYPE_CODE" "PRORATION_TYPE_CODE", "A37"."INCLUDE_ON_RETURNS_FLAG" "INCLUDE_ON_RETURNS_FLAG", "A37"."CREDIT_OR_CHARGE_FLAG" "CREDIT_OR_CHARGE_FLAG", "A37"."AC_CONTEXT" "AC_CONTEXT", "A37"."AC_ATTRIBUTE1" "AC_ATTRIBUTE1", "A37"."AC_ATTRIBUTE2" "AC_ATTRIBUTE2", "A37"."AC_ATTRIBUTE3" "AC_ATTRIBUTE3", "A37"."AC_ATTRIBUTE4" "AC_ATTRIBUTE4", "A37"."AC_ATTRIBUTE5" "AC_ATTRIBUTE5", "A37"."AC_ATTRIBUTE6" "AC_ATTRIBUTE6", "A37"."AC_ATTRIBUTE7" "AC_ATTRIBUTE7", "A37"."AC_ATTRIBUTE8" "AC_ATTRIBUTE8", "A37"."AC_ATTRIBUTE9" "AC_ATTRIBUTE9", "A37"."AC_ATTRIBUTE10" "AC_ATTRIBUTE10", "A37"."AC_ATTRIBUTE11" "AC_ATTRIBUTE11", "A37"."AC_ATTRIBUTE12" "AC_ATTRIBUTE12", "A37"."AC_ATTRIBUTE13" "AC_ATTRIBUTE13", "A37"."AC_ATTRIBUTE14" "AC_ATTRIBUTE14"
, "A37"."AC_ATTRIBUTE15" "AC_ATTRIBUTE15", "A37"."LOCK_CONTROL" "LOCK_CONTROL", "A37"."OPERAND_PER_PQTY" "OPERAND_PER_PQTY", "A37"."ADJUSTED_AMOUNT_PER_PQTY" "ADJUSTED_AMOUNT_PER_PQTY", "A37"."INTERCO_INVOICED_FLAG" "INTERCO_INVOICED_FLAG", "A37"."INVOICED_AMOUNT" "INVOICED_AMOUNT", "A37"."RETROBILL_REQUEST_ID" "RETROBILL_REQUEST_ID", "A37"."TAX_RATE_ID" "TAX_RATE_ID" FROM "PO_PRICE_ADJUSTMENTS_XML" "A37" WHERE "A37"."PO_HEADER_ID"="A2"."PO_HEADER_ID" AND "A37"."PO_LINE_ID"="A2"."PO_LINE_ID" AND "A37"."PARENT_ADJUSTMENT_ID" IS NULL ORDER BY "A37"."PRICING_GROUP_SEQUENCE") "PRICE_MODIFIERS", CURSOR (SELECT "A36"."PRICE_ADJUSTMENT_ID" "PRICE_ADJUSTMENT_ID", "A36"."CREATION_DATE" "CREATION_DATE", "A36"."CREATED_BY" "CREATED_BY", "A36"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A36"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A36"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A36"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A36"."PROGRAM_ID" "PROGRAM_ID", "A36"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A36"."REQUEST_ID" "REQUEST_ID", "A36"."PO_HEADER_ID" "PO_HEADER_ID", "A36"."AUTOMATIC_FLAG" "AUTOMATIC_FLAG", "A36"."PO_LINE_ID" "PO_LINE_ID", "A36"."ADJ_LINE_NUM" "ADJ_LINE_NUM", "A36"."CONTEXT" "CONTEXT", "A36"."ATTRIBUTE1" "ATTRIBUTE1", "A36"."ATTRIBUTE2" "ATTRIBUTE2", "A36"."ATTRIBUTE3" "ATTRIBUTE3", "A36"."ATTRIBUTE4" "ATTRIBUTE4", "A36"."ATTRIBUTE5" "ATTRIBUTE5", "A36"."ATTRIBUTE6" "ATTRIBUTE6", "A36"."ATTRIBUTE7" "ATTRIBUTE7", "A36"."ATTRIBUTE8" "ATTRIBUTE8", "A36"."ATTRIBUTE9" "ATTRIBUTE9", "A36"."ATTRIBUTE10" "ATTRIBUTE10", "A36"."ATTRIBUTE11" "ATTRIBUTE11", "A36"."ATTRIBUTE12" "ATTRIBUTE12", "A36"."ATTRIBUTE13" "ATTRIBUTE13", "A36"."ATTRIBUTE14" "ATTRIBUTE14", "A36"."ATTRIBUTE15" "ATTRIBUTE15", "A36"."ORIG_SYS_DISCOUNT_REF" "ORIG_SYS_DISCOUNT_REF", "A36"."CHANGE_SEQUENCE" "CHANGE_SEQUENCE", "A36"."LIST_HEADER_ID" "LIST_HEADER_ID", "A36"."LIST_TYPE_CODE" "LIST_TYPE_CODE", "A36"."LIST_LINE_ID" "LIST_LINE_ID", "A36"."MODIFIER_DESC" "MODIFIER_DESC", "A36"."LIST_LINE_TYPE_CODE" "LIST_LINE_TYPE_CODE", "A36"."MODIFIER_LINE_TYPE" "MODIFIER_LINE_TYPE", "A36"."MODIFIED_FROM" "MODIFIED_FROM", "A36"."MODIFIED_TO" "MODIFIED_TO", "A36"."UPDATE_ALLOWED" "UPDATE_ALLOWED", "A36"."CHANGE_REASON_CODE" "CHANGE_REASON_CODE", "A36"."CHANGE_REASON_TEXT" "CHANGE_REASON_TEXT", "A36"."UP
DATED_FLAG" "UPDATED_FLAG", "A36"."APPLIED_FLAG" "APPLIED_FLAG", "A36"."OPERAND" "OPERAND", "A36"."ARITHMETIC_OPERATOR" "ARITHMETIC_OPERATOR", "A36"."COST_ID" "COST_ID", "A36"."TAX_CODE" "TAX_CODE", "A36"."TAX_EXEMPT_FLAG" "TAX_EXEMPT_FLAG", "A36"."TAX_EXEMPT_NUMBER" "TAX_EXEMPT_NUMBER", "A36"."TAX_EXEMPT_REASON_CODE" "TAX_EXEMPT_REASON_CODE", "A36"."PARENT_ADJUSTMENT_ID" "PARENT_ADJUSTMENT_ID", "A36"."INVOICED_FLAG" "INVOICED_FLAG", "A36"."ESTIMATED_FLAG" "ESTIMATED_FLAG", "A36"."INC_IN_SALES_PERFORMANCE" "INC_IN_SALES_PERFORMANCE", "A36"."ADJUSTED_AMOUNT" "ADJUSTED_AMOUNT", "A36"."PRICING_PHASE_ID" "PRICING_PHASE_ID", "A36"."CHARGE_TYPE_CODE" "CHARGE_TYPE_CODE", "A36"."CHARGE_SUBTYPE_CODE" "CHARGE_SUBTYPE_CODE", "A36"."RANGE_BREAK_QUANTITY" "RANGE_BREAK_QUANTITY", "A36"."ACCRUAL_CONVERSION_RATE" "ACCRUAL_CONVERSION_RATE", "A36"."PRICING_GROUP_SEQUENCE" "PRICING_GROUP_SEQUENCE", "A36"."ACCRUAL_FLAG" "ACCRUAL_FLAG", "A36"."LIST_LINE_NO" "LIST_LINE_NO", "A36"."SOURCE_SYSTEM_CODE" "SOURCE_SYSTEM_CODE", "A36"."BENEFIT_QTY" "BENEFIT_QTY", "A36"."BENEFIT_UOM_CODE" "BENEFIT_UOM_CODE", "A36"."PRINT_ON_INVOICE_FLAG" "PRINT_ON_INVOICE_FLAG", "A36"."EXPIRATION_DATE" "EXPIRATION_DATE", "A36"."REBATE_TRANSACTION_TYPE_CODE" "REBATE_TRANSACTION_TYPE_CODE", "A36"."REBATE_TRANSACTION_REFERENCE" "REBATE_TRANSACTION_REFERENCE", "A36"."REBATE_PAYMENT_SYSTEM_CODE" "REBATE_PAYMENT_SYSTEM_CODE", "A36"."REDEEMED_DATE" "REDEEMED_DATE", "A36"."REDEEMED_FLAG" "REDEEMED_FLAG", "A36"."MODIFIER_LEVEL_CODE" "MODIFIER_LEVEL_CODE", "A36"."PRICE_BREAK_TYPE_CODE" "PRICE_BREAK_TYPE_CODE", "A36"."SUBSTITUTION_ATTRIBUTE" "SUBSTITUTION_ATTRIBUTE", "A36"."PRORATION_TYPE_CODE" "PRORATION_TYPE_CODE", "A36"."INCLUDE_ON_RETURNS_FLAG" "INCLUDE_ON_RETURNS_FLAG", "A36"."CREDIT_OR_CHARGE_FLAG" "CREDIT_OR_CHARGE_FLAG", "A36"."AC_CONTEXT" "AC_CONTEXT", "A36"."AC_ATTRIBUTE1" "AC_ATTRIBUTE1", "A36"."AC_ATTRIBUTE2" "AC_ATTRIBUTE2", "A36"."AC_ATTRIBUTE3" "AC_ATTRIBUTE3", "A36"."AC_ATTRIBUTE4" "AC_ATTRIBUTE4", "A36"."AC_ATTRIBUTE5" "AC_ATTRIBUTE5", "A36"."AC_ATTRIBUTE6" "AC_ATTRIBUTE6", "A36"."AC_ATTRIBUTE7" "AC_ATTRIBUTE7", "A36"."AC_ATTRIBUTE8" "AC_ATTRIBUTE8", "A36"."AC_ATTRIBUTE9" "AC_ATTRIBUTE9", "A36"."AC_ATTRIBUTE10" "AC_ATTRIBUTE10", "A36"."AC_ATTRIBUTE11" "AC_ATTRIBUTE11", "A36"."AC_ATTRIBUTE12" "AC_ATTRIBUTE12", "A36"."AC_ATTRIBUTE13" "AC_ATTRIBUTE13", "A36"."AC_ATTRIBUTE14" "AC_ATTRIBUTE14", "A36"."AC_ATTRIBUT
E15" "AC_ATTRIBUTE15", "A36"."LOCK_CONTROL" "LOCK_CONTROL", "A36"."OPERAND_PER_PQTY" "OPERAND_PER_PQTY", "A36"."ADJUSTED_AMOUNT_PER_PQTY" "ADJUSTED_AMOUNT_PER_PQTY", "A36"."INTERCO_INVOICED_FLAG" "INTERCO_INVOICED_FLAG", "A36"."INVOICED_AMOUNT" "INVOICED_AMOUNT", "A36"."RETROBILL_REQUEST_ID" "RETROBILL_REQUEST_ID", "A36"."TAX_RATE_ID" "TAX_RATE_ID" FROM "PO_PRICE_ADJUSTMENTS_XML" "A36" WHERE "A36"."PO_HEADER_ID"="A2"."FROM_HEADER_ID" AND "A36"."PO_LINE_ID"="A2"."FROM_LINE_ID" AND "A36"."PARENT_ADJUSTMENT_ID" IS NULL ORDER BY "A36"."PRICING_GROUP_SEQUENCE") "ADD_PRICE_MODIFIERS", CURSOR (SELECT "A35"."SEGMENT1" "PONUM" FROM "PO"."PO_HEADERS_ALL" "A35" WHERE "A35"."PO_HEADER_ID"="A2"."FROM_HEADER_ID") "ADD_PRICE_PONUM", CURSOR (SELECT "A34"."URL" "WEB_PAGE" FROM "FND_ATTACHED_DOCS_FORM_VL" "A34" WHERE ("A34"."ENTITY_NAME"='PO_LINES' AND "A34"."PK1_VALUE"=TO_CHAR("A2"."PO_LINE_ID") OR "A34"."ENTITY_NAME"='PO_HEADERS' AND "A34"."PK1_VALUE"=TO_CHAR("A2"."FROM_HEADER_ID") AND "A2"."FROM_HEADER_ID" IS NOT NULL OR "A34"."ENTITY_NAME"='PO_IN_GA_LINES' AND "A34"."PK1_VALUE"=TO_CHAR("A2"."FROM_LINE_ID") AND "A2"."FROM_LINE_ID" IS NOT NULL OR "A34"."ENTITY_NAME"='PO_HEADERS' AND "A34"."PK1_VALUE"=TO_CHAR("A2"."CONTRACT_ID") AND "A2"."CONTRACT_ID" IS NOT NULL OR "A34"."ENTITY_NAME"='MTL_SYSTEM_ITEMS' AND "A34"."PK1_VALUE"=TO_CHAR("APPS"."PO_COMMUNICATION_PVT"."GETINVENTORYORGID"()) AND "A34"."PK2_VALUE"=TO_CHAR("A2"."ITEM_ID") AND "A2"."ITEM_ID" IS NOT NULL) AND "A34"."DATATYPE_ID"=5 AND "A34"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A34"."SEQ_NUM") "LINE_URL_ATTACHMENTS", CURSOR (SELECT "A33"."FILE_NAME" "FILE_NAME" FROM "FND_ATTACHED_DOCS_FORM_VL" "A33" WHERE ("A33"."ENTITY_NAME"='PO_LINES' AND "A33"."PK1_VALUE"=TO_CHAR("A2"."PO_LINE_ID") OR "A33"."ENTITY_NAME"='PO_HEADERS' AND "A33"."PK1_VALUE"=TO_CHAR("A2"."FROM_HEADER_ID") AND "A2"."FROM_HEADER_ID" IS NOT NULL OR "A33"."ENTITY_NAME"='PO_IN_GA_LINES' AND "A33"."PK1_VALUE"=TO_CHAR("A2"."FROM_LINE_ID") AND "A2"."FROM_LINE_ID" IS NOT NULL OR "A33"."ENTITY_NAME"='PO_HEADERS' AND "A33"."PK1_VALUE"=TO_CHAR("A2"."CONTRACT_ID") AND "A2"."CONTRACT_ID" IS NOT NULL OR "A33"."ENTITY_NAME"='MTL_SYSTEM_ITEMS' AND "A33"."PK1_VALUE"=TO_CHAR("APPS"."PO_COMMUNICATION_PVT"."GETINVENTORYORGID"()) AND "A33"."PK2_VALUE"=TO_CHAR("A2"."ITEM_ID") AND "A2"."ITEM_ID" IS NOT NULL) AND "A33"."DATATYPE_ID"=6 AND "A33"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A33"."SEQ_NUM")
"LINE_FILE_ATTACHMENTS", CURSOR (SELECT "A32"."SHIPMENT_NUM" "SHIPMENT_NUM", "A32"."DUE_DATE" "DUE_DATE", "A32"."QUANTITY" "QUANTITY", "A32"."PRICE_OVERRIDE" "PRICE_OVERRIDE", "A32"."QUANTITY_CANCELLED" "QUANTITY_CANCELLED", "A32"."CANCEL_FLAG" "CANCEL_FLAG", "A32"."CANCEL_DATE" "CANCEL_DATE", "A32"."CANCEL_REASON" "CANCEL_REASON", "A32"."TAXABLE_FLAG" "TAXABLE_FLAG", "A32"."START_DATE" "START_DATE", "A32"."END_DATE" "END_DATE", "A32"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A32"."ATTRIBUTE1" "ATTRIBUTE1", "A32"."ATTRIBUTE2" "ATTRIBUTE2", "A32"."ATTRIBUTE3" "ATTRIBUTE3", "A32"."ATTRIBUTE4" "ATTRIBUTE4", "A32"."ATTRIBUTE5" "ATTRIBUTE5", "A32"."ATTRIBUTE6" "ATTRIBUTE6", "A32"."ATTRIBUTE7" "ATTRIBUTE7", "A32"."ATTRIBUTE8" "ATTRIBUTE8", "A32"."ATTRIBUTE9" "ATTRIBUTE9", "A32"."ATTRIBUTE10" "ATTRIBUTE10", "A32"."ATTRIBUTE11" "ATTRIBUTE11", "A32"."ATTRIBUTE12" "ATTRIBUTE12", "A32"."ATTRIBUTE13" "ATTRIBUTE13", "A32"."ATTRIBUTE14" "ATTRIBUTE14", "A32"."ATTRIBUTE15" "ATTRIBUTE15", "A32"."PO_HEADER_ID" "PO_HEADER_ID", "A32"."PO_LINE_ID" "PO_LINE_ID", "A32"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A32"."SHIPMENT_TYPE" "SHIPMENT_TYPE", "A32"."PO_RELEASE_ID" "PO_RELEASE_ID", "A32"."CONSIGNED_FLAG" "CONSIGNED_FLAG", "A32"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A32"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A32"."RECEIVING_ROUTING_ID" "RECEIVING_ROUTING_ID", "A32"."ACCRUE_ON_RECEIPT_FLAG" "ACCRUE_ON_RECEIPT_FLAG", "A32"."CLOSED_REASON" "CLOSED_REASON", "A32"."CLOSED_DATE" "CLOSED_DATE", "A32"."CLOSED_BY" "CLOSED_BY", "A32"."ORG_ID" "ORG_ID", "A32"."UNIT_OF_MEASURE_CLASS" "UNIT_OF_MEASURE_CLASS", "A32"."ENCUMBER_NOW" "ENCUMBER_NOW", "A32"."INSPECTION_REQUIRED_FLAG" "INSPECTION_REQUIRED_FLAG", "A32"."RECEIPT_REQUIRED_FLAG" "RECEIPT_REQUIRED_FLAG", "A32"."QTY_RCV_TOLERANCE" "QTY_RCV_TOLERANCE", "A32"."QTY_RCV_EXCEPTION_CODE" "QTY_RCV_EXCEPTION_CODE", "A32"."ENFORCE_SHIP_TO_LOCATION_CODE" "ENFORCE_SHIP_TO_LOCATION_CODE", "A32"."ALLOW_SUBSTITUTE_RECEIPTS_FLAG" "ALLOW_SUBSTITUTE_RECEIPTS_FLAG", "A32"."DAYS_EARLY_RECEIPT_ALLOWED" "DAYS_EARLY_RECEIPT_ALLOWED", "A32"."DAYS_LATE_RECEIPT_ALLOWED" "DAYS_LATE_RECEIPT_ALLOWED", "A32"."RECEIPT_DAYS_EXCEPTION_CODE" "RECEIPT_DAYS_EXCEPTION_CODE", "A32"."INVOICE_CLOSE_TOLERANCE" "INVOICE_CLOSE_TOLERANCE", "A32"."RECEIVE_CLOSE_TOLERANCE" "RECEIVE_CLOSE_TOLERANCE", "A32"."SHIP_TO_OR
GANIZATION_ID" "SHIP_TO_ORGANIZATION_ID", "A32"."SOURCE_SHIPMENT_ID" "SOURCE_SHIPMENT_ID", "A32"."CLOSED_CODE" "CLOSED_CODE", "A32"."REQUEST_ID" "REQUEST_ID", "A32"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A32"."PROGRAM_ID" "PROGRAM_ID", "A32"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A32"."LAST_ACCEPT_DATE" "LAST_ACCEPT_DATE", "A32"."ENCUMBERED_FLAG" "ENCUMBERED_FLAG", "A32"."ENCUMBERED_DATE" "ENCUMBERED_DATE", "A32"."UNENCUMBERED_QUANTITY" "UNENCUMBERED_QUANTITY", "A32"."FOB_LOOKUP_CODE" "FOB_LOOKUP_CODE", "A32"."FREIGHT_TERMS_LOOKUP_CODE" "FREIGHT_TERMS_LOOKUP_CODE", "A32"."ESTIMATED_TAX_AMOUNT" "ESTIMATED_TAX_AMOUNT", "A32"."FROM_HEADER_ID" "FROM_HEADER_ID", "A32"."FROM_LINE_ID" "FROM_LINE_ID", "A32"."FROM_LINE_LOCATION_ID" "FROM_LINE_LOCATION_ID", "A32"."LEAD_TIME" "LEAD_TIME", "A32"."LEAD_TIME_UNIT" "LEAD_TIME_UNIT", "A32"."PRICE_DISCOUNT" "PRICE_DISCOUNT", "A32"."TERMS_ID" "TERMS_ID", "A32"."APPROVED_FLAG" "APPROVED_FLAG", "A32"."APPROVED_DATE" "APPROVED_DATE", "A32"."CLOSED_FLAG" "CLOSED_FLAG", "A32"."CANCELLED_BY" "CANCELLED_BY", "A32"."FIRM_STATUS_LOOKUP_CODE" "FIRM_STATUS_LOOKUP_CODE", "A32"."FIRM_DATE" "FIRM_DATE", "A32"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A32"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A32"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A32"."CREATION_DATE" "CREATION_DATE", "A32"."CREATED_BY" "CREATED_BY", "A32"."QUANTITY_RECEIVED" "QUANTITY_RECEIVED", "A32"."QUANTITY_ACCEPTED" "QUANTITY_ACCEPTED", "A32"."QUANTITY_REJECTED" "QUANTITY_REJECTED", "A32"."QUANTITY_BILLED" "QUANTITY_BILLED", "A32"."UNIT_MEAS_LOOKUP_CODE" "UNIT_MEAS_LOOKUP_CODE", "A32"."SHIP_VIA_LOOKUP_CODE" "SHIP_VIA_LOOKUP_CODE", "A32"."GLOBAL_ATTRIBUTE_CATEGORY" "GLOBAL_ATTRIBUTE_CATEGORY", "A32"."GLOBAL_ATTRIBUTE1" "GLOBAL_ATTRIBUTE1", "A32"."GLOBAL_ATTRIBUTE2" "GLOBAL_ATTRIBUTE2", "A32"."GLOBAL_ATTRIBUTE3" "GLOBAL_ATTRIBUTE3", "A32"."GLOBAL_ATTRIBUTE4" "GLOBAL_ATTRIBUTE4", "A32"."GLOBAL_ATTRIBUTE5" "GLOBAL_ATTRIBUTE5", "A32"."GLOBAL_ATTRIBUTE6" "GLOBAL_ATTRIBUTE6", "A32"."GLOBAL_ATTRIBUTE7" "GLOBAL_ATTRIBUTE7", "A32"."GLOBAL_ATTRIBUTE8" "GLOBAL_ATTRIBUTE8", "A32"."GLOBAL_ATTRIBUTE9" "GLOBAL_ATTRIBUTE9", "A32"."GLOBAL_ATTRIBUTE10" "GLOBAL_ATTRIBUTE10", "A32"."GLOBAL_ATTRIBUTE11" "GLOBAL_ATTRIBUTE11", "A32"."GLOBAL_ATTRIBUTE12" "GLOBAL_ATTRIBUTE12", "A32"."GLOBAL_ATTRIBUTE13" "GLOBAL_ATTRIBUTE13", "A32"."GLOBAL_ATTRIBUTE14" "GLOBAL_ATTRIBUTE14", "A32"."GLOBAL_ATTRIB
UTE15" "GLOBAL_ATTRIBUTE15", "A32"."GLOBAL_ATTRIBUTE16" "GLOBAL_ATTRIBUTE16", "A32"."GLOBAL_ATTRIBUTE17" "GLOBAL_ATTRIBUTE17", "A32"."GLOBAL_ATTRIBUTE18" "GLOBAL_ATTRIBUTE18", "A32"."GLOBAL_ATTRIBUTE19" "GLOBAL_ATTRIBUTE19", "A32"."GLOBAL_ATTRIBUTE20" "GLOBAL_ATTRIBUTE20", "A32"."QUANTITY_SHIPPED" "QUANTITY_SHIPPED", "A32"."COUNTRY_OF_ORIGIN_CODE" "COUNTRY_OF_ORIGIN_CODE", "A32"."TAX_USER_OVERRIDE_FLAG" "TAX_USER_OVERRIDE_FLAG", "A32"."MATCH_OPTION" "MATCH_OPTION", "A32"."TAX_CODE_ID" "TAX_CODE_ID", "A32"."CALCULATE_TAX_FLAG" "CALCULATE_TAX_FLAG", "A32"."CHANGE_PROMISED_DATE_REASON" "CHANGE_PROMISED_DATE_REASON", "A32"."NOTE_TO_RECEIVER" "NOTE_TO_RECEIVER", "A32"."SECONDARY_UNIT_OF_MEASURE" "SECONDARY_UNIT_OF_MEASURE", "A32"."SECONDARY_QUANTITY" "SECONDARY_QUANTITY", "A32"."PREFERRED_GRADE" "PREFERRED_GRADE", "A32"."SECONDARY_QUANTITY_RECEIVED" "SECONDARY_QUANTITY_RECEIVED", "A32"."SECONDARY_QUANTITY_ACCEPTED" "SECONDARY_QUANTITY_ACCEPTED", "A32"."SECONDARY_QUANTITY_REJECTED" "SECONDARY_QUANTITY_REJECTED", "A32"."SECONDARY_QUANTITY_CANCELLED" "SECONDARY_QUANTITY_CANCELLED", "A32"."VMI_FLAG" "VMI_FLAG", "A32"."RETROACTIVE_DATE" "RETROACTIVE_DATE", "A32"."SUPPLIER_ORDER_LINE_NUMBER" "SUPPLIER_ORDER_LINE_NUMBER", "A32"."AMOUNT" "AMOUNT", "A32"."AMOUNT_RECEIVED" "AMOUNT_RECEIVED", "A32"."AMOUNT_BILLED" "AMOUNT_BILLED", "A32"."AMOUNT_CANCELLED" "AMOUNT_CANCELLED", "A32"."AMOUNT_ACCEPTED" "AMOUNT_ACCEPTED", "A32"."AMOUNT_REJECTED" "AMOUNT_REJECTED", "A32"."DROP_SHIP_FLAG" "DROP_SHIP_FLAG", "A32"."SALES_ORDER_UPDATE_DATE" "SALES_ORDER_UPDATE_DATE", "A32"."SHIP_TO_LOCATION_ID" "SHIP_TO_LOCATION_ID", "A32"."SHIP_TO_LOCATION_NAME" "SHIP_TO_LOCATION_NAME", "A32"."SHIP_TO_ADDRESS_LINE1" "SHIP_TO_ADDRESS_LINE1", "A32"."SHIP_TO_ADDRESS_LINE2" "SHIP_TO_ADDRESS_LINE2", "A32"."SHIP_TO_ADDRESS_LINE3" "SHIP_TO_ADDRESS_LINE3", "A32"."SHIP_TO_ADDRESS_LINE4" "SHIP_TO_ADDRESS_LINE4", "A32"."SHIP_TO_ADDRESS_INFO" "SHIP_TO_ADDRESS_INFO", "A32"."SHIP_TO_COUNTRY" "SHIP_TO_COUNTRY", "A32"."IS_SHIPMENT_ONE_TIME_LOC" "IS_SHIPMENT_ONE_TIME_LOC", "A32"."ONE_TIME_ADDRESS_DETAILS" "ONE_TIME_ADDRESS_DETAILS", "A32"."DETAILS" "DETAILS", "A32"."SHIP_CONT_PHONE" "SHIP_CONT_PHONE", "A32"."SHIP_CONT_EMAIL" "SHIP_CONT_EMAIL", "A32"."ULTIMATE_DELIVER_CONT_PHONE" "ULTIMATE_DELIVER_CONT_PHONE", "A32"."ULTIMATE_DELIVER_CONT_EMAIL" "ULTIMATE_DELIVER_CONT_EMAIL", "A32"."SHIP_CONT_NAME" "SHIP_CONT_NAME", "A32"."ULTIMATE_DELIVER_CONT_NAME" "ULTIMATE_DELIVER_CONT_NAME", "A32"."SHIP_CUST_NAME" "SHIP_CUST_NAME", "A32
"."SHIP_CUST_LOCATION" "SHIP_CUST_LOCATION", "A32"."ULTIMATE_DELIVER_CUST_NAME" "ULTIMATE_DELIVER_CUST_NAME", "A32"."ULTIMATE_DELIVER_CUST_LOCATION" "ULTIMATE_DELIVER_CUST_LOCATION", "A32"."SHIP_TO_CONTACT_FAX" "SHIP_TO_CONTACT_FAX", "A32"."ULTIMATE_DELIVER_TO_CONT_NAME" "ULTIMATE_DELIVER_TO_CONT_NAME", "A32"."ULTIMATE_DELIVER_TO_CONT_FAX" "ULTIMATE_DELIVER_TO_CONT_FAX", "A32"."SHIPPING_METHOD" "SHIPPING_METHOD", "A32"."SHIPPING_INSTRUCTIONS" "SHIPPING_INSTRUCTIONS", "A32"."PACKING_INSTRUCTIONS" "PACKING_INSTRUCTIONS", "A32"."CUSTOMER_PRODUCT_DESC" "CUSTOMER_PRODUCT_DESC", "A32"."CUSTOMER_PO_NUM" "CUSTOMER_PO_NUM", "A32"."CUSTOMER_PO_LINE_NUM" "CUSTOMER_PO_LINE_NUM", "A32"."CUSTOMER_PO_SHIPMENT_NUM" "CUSTOMER_PO_SHIPMENT_NUM", "A32"."NEED_BY_DATE" "NEED_BY_DATE", "A32"."PROMISED_DATE" "PROMISED_DATE", "A32"."TOTAL_SHIPMENT_AMOUNT" "TOTAL_SHIPMENT_AMOUNT", "A32"."FINAL_MATCH_FLAG" "FINAL_MATCH_FLAG", "A32"."MANUAL_PRICE_CHANGE_FLAG" "MANUAL_PRICE_CHANGE_FLAG", "A32"."TAX_NAME" "TAX_NAME", "A32"."TRANSACTION_FLOW_HEADER_ID" "TRANSACTION_FLOW_HEADER_ID", "A32"."VALUE_BASIS" "VALUE_BASIS", "A32"."MATCHING_BASIS" "MATCHING_BASIS", "A32"."PAYMENT_TYPE" "PAYMENT_TYPE", "A32"."DESCRIPTION" "DESCRIPTION", "A32"."QUANTITY_FINANCED" "QUANTITY_FINANCED", "A32"."AMOUNT_FINANCED" "AMOUNT_FINANCED", "A32"."QUANTITY_RECOUPED" "QUANTITY_RECOUPED", "A32"."AMOUNT_RECOUPED" "AMOUNT_RECOUPED", "A32"."RETAINAGE_WITHHELD_AMOUNT" "RETAINAGE_WITHHELD_AMOUNT", "A32"."RETAINAGE_RELEASED_AMOUNT" "RETAINAGE_RELEASED_AMOUNT", "A32"."WORK_APPROVER_ID" "WORK_APPROVER_ID", "A32"."BID_PAYMENT_ID" "BID_PAYMENT_ID", "A32"."AMOUNT_SHIPPED" "AMOUNT_SHIPPED", CURSOR (SELECT "A32"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A89"."SHORT_TEXT" "SHORT_TEXT" FROM "FND_ATTACHED_DOCS_FORM_VL" "A90", "APPLSYS"."FND_DOCUMENTS_SHORT_TEXT" "A89" WHERE "A90"."ENTITY_NAME"='PO_SHIPMENTS' AND "A90"."PK1_VALUE"=TO_CHAR("A32"."LINE_LOCATION_ID") AND "A90"."FUNCTION_NAME"='PO_PRINTPO' AND "A90"."MEDIA_ID"="A89"."MEDIA_ID" AND "A90"."DATATYPE_ID"=1 ORDER BY "A90"."SEQ_NUM") "LINE_LOC_SHORT_TEXT", CURSOR (SELECT "A88"."URL" "WEB_PAGE" FROM "FND_ATTACHED_DOCS_FORM_VL" "A88" WHERE "A88"."ENTITY_NAME"='PO_SHIPMENTS' AND "A88"."PK1_VALUE"=TO_CHAR("A32"."LINE_LOCATION_ID") AND "A88"."DATATYPE_ID"=5 AND "A88"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A88"."SEQ_NUM") "LINE_LOC_URL_ATTACHMENTS", CURSOR (SELECT "A87"."FILE_NAME" "FILE_NAME" FROM "FND_ATTACHED_DOCS_FORM_VL" "A87" WHERE "A87"."ENTITY_NAME"='PO_SHIPM
ENTS' AND "A87"."PK1_VALUE"=TO_CHAR("A32"."LINE_LOCATION_ID") AND "A87"."DATATYPE_ID"=6 AND "A87"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A87"."SEQ_NUM") "LINE_LOC_FILE_ATTACHMENTS", CURSOR (SELECT "A86"."AMOUNT_ORDERED" "AMOUNT_ORDERED", "A86"."AMOUNT_DELIVERED" "AMOUNT_DELIVERED", "A86"."AMOUNT_CANCELLED" "AMOUNT_CANCELLED", "A86"."DISTRIBUTION_TYPE" "DISTRIBUTION_TYPE", "A86"."AMOUNT_TO_ENCUMBER" "AMOUNT_TO_ENCUMBER", "A86"."INVOICE_ADJUSTMENT_FLAG" "INVOICE_ADJUSTMENT_FLAG", "A86"."DEST_CHARGE_ACCOUNT_ID" "DEST_CHARGE_ACCOUNT_ID", "A86"."DEST_VARIANCE_ACCOUNT_ID" "DEST_VARIANCE_ACCOUNT_ID", "A86"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A86"."PROJECT_ID" "PROJECT_ID", "A86"."TASK_ID" "TASK_ID", "A86"."EXPENDITURE_TYPE" "EXPENDITURE_TYPE", "A86"."PROJECT_ACCOUNTING_CONTEXT" "PROJECT_ACCOUNTING_CONTEXT", "A86"."EXPENDITURE_ORGANIZATION_ID" "EXPENDITURE_ORGANIZATION_ID", "A86"."GL_CLOSED_DATE" "GL_CLOSED_DATE", "A86"."ACCRUE_ON_RECEIPT_FLAG" "ACCRUE_ON_RECEIPT_FLAG", "A86"."EXPENDITURE_ITEM_DATE" "EXPENDITURE_ITEM_DATE", "A86"."ORG_ID" "ORG_ID", "A86"."GL_ENCUMBERED_PERIOD_NAME" "GL_ENCUMBERED_PERIOD_NAME", "A86"."GL_CANCELLED_DATE" "GL_CANCELLED_DATE", "A86"."DESTINATION_TYPE_CODE" "DESTINATION_TYPE_CODE", "A86"."DESTINATION_ORGANIZATION_ID" "DESTINATION_ORGANIZATION_ID", "A86"."DESTINATION_SUBINVENTORY" "DESTINATION_SUBINVENTORY", "A86"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A86"."ATTRIBUTE1" "ATTRIBUTE1", "A86"."ATTRIBUTE2" "ATTRIBUTE2", "A86"."ATTRIBUTE3" "ATTRIBUTE3", "A86"."ATTRIBUTE4" "ATTRIBUTE4", "A86"."ATTRIBUTE5" "ATTRIBUTE5", "A86"."ATTRIBUTE6" "ATTRIBUTE6", "A86"."ATTRIBUTE7" "ATTRIBUTE7", "A86"."ATTRIBUTE8" "ATTRIBUTE8", "A86"."ATTRIBUTE9" "ATTRIBUTE9", "A86"."ATTRIBUTE10" "ATTRIBUTE10", "A86"."ATTRIBUTE11" "ATTRIBUTE11", "A86"."ATTRIBUTE12" "ATTRIBUTE12", "A86"."ATTRIBUTE13" "ATTRIBUTE13", "A86"."ATTRIBUTE14" "ATTRIBUTE14", "A86"."ATTRIBUTE15" "ATTRIBUTE15", "A86"."WIP_ENTITY_ID" "WIP_ENTITY_ID", "A86"."WIP_OPERATION_SEQ_NUM" "WIP_OPERATION_SEQ_NUM", "A86"."WIP_RESOURCE_SEQ_NUM" "WIP_RESOURCE_SEQ_NUM", "A86"."WIP_REPETITIVE_SCHEDULE_ID" "WIP_REPETITIVE_SCHEDULE_ID", "A86"."WIP_LINE_ID" "WIP_LINE_ID", "A86"."BOM_RESOURCE_ID" "BOM_RESOURCE_ID", "A86"."BUDGET_ACCOUNT_ID" "BUDGET_ACCOUNT_ID", "A86"."ACCRUAL_ACCOUNT_ID" "ACCRUAL_ACCOUNT_ID", "A86"."VARIANCE_ACCOUNT_ID" "VARIANCE_ACCOUNT_ID", "A86"."PREVENT_ENCUMBRANCE_FLAG" "PREVENT_ENCUMBRANCE_FLAG", "
A86"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A86"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A86"."PO_DISTRIBUTION_ID" "PO_DISTRIBUTION_ID", "A86"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A86"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A86"."PO_HEADER_ID" "PO_HEADER_ID", "A86"."PO_LINE_ID" "PO_LINE_ID", "A86"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A86"."SET_OF_BOOKS_ID" "SET_OF_BOOKS_ID", "A86"."CODE_COMBINATION_ID" "CODE_COMBINATION_ID", "A86"."QUANTITY_ORDERED" "QUANTITY_ORDERED", "A86"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A86"."CREATION_DATE" "CREATION_DATE", "A86"."CREATED_BY" "CREATED_BY", "A86"."PO_RELEASE_ID" "PO_RELEASE_ID", "A86"."QUANTITY_DELIVERED" "QUANTITY_DELIVERED", "A86"."QUANTITY_BILLED" "QUANTITY_BILLED", "A86"."QUANTITY_CANCELLED" "QUANTITY_CANCELLED", "A86"."REQ_HEADER_REFERENCE_NUM" "REQ_HEADER_REFERENCE_NUM", "A86"."REQ_LINE_REFERENCE_NUM" "REQ_LINE_REFERENCE_NUM", "A86"."REQ_DISTRIBUTION_ID" "REQ_DISTRIBUTION_ID", "A86"."DELIVER_TO_LOCATION_ID" "DELIVER_TO_LOCATION_ID", "A86"."DELIVER_TO_PERSON_ID" "DELIVER_TO_PERSON_ID", "A86"."RATE_DATE" "RATE_DATE", "A86"."RATE" "RATE", "A86"."AMOUNT_BILLED" "AMOUNT_BILLED", "A86"."ACCRUED_FLAG" "ACCRUED_FLAG", "A86"."ENCUMBERED_FLAG" "ENCUMBERED_FLAG", "A86"."ENCUMBERED_AMOUNT" "ENCUMBERED_AMOUNT", "A86"."UNENCUMBERED_QUANTITY" "UNENCUMBERED_QUANTITY", "A86"."UNENCUMBERED_AMOUNT" "UNENCUMBERED_AMOUNT", "A86"."FAILED_FUNDS_LOOKUP_CODE" "FAILED_FUNDS_LOOKUP_CODE", "A86"."GL_ENCUMBERED_DATE" "GL_ENCUMBERED_DATE", "A86"."KANBAN_CARD_ID" "KANBAN_CARD_ID", "A86"."END_ITEM_UNIT_NUMBER" "END_ITEM_UNIT_NUMBER", "A86"."AWARD_ID" "AWARD_ID", "A86"."MRC_RATE_DATE" "MRC_RATE_DATE", "A86"."MRC_RATE" "MRC_RATE", "A86"."MRC_ENCUMBERED_AMOUNT" "MRC_ENCUMBERED_AMOUNT", "A86"."MRC_UNENCUMBERED_AMOUNT" "MRC_UNENCUMBERED_AMOUNT", "A86"."RECOVERABLE_TAX" "RECOVERABLE_TAX", "A86"."NONRECOVERABLE_TAX" "NONRECOVERABLE_TAX", "A86"."RECOVERY_RATE" "RECOVERY_RATE", "A86"."TAX_RECOVERY_OVERRIDE_FLAG" "TAX_RECOVERY_OVERRIDE_FLAG", "A86"."OKE_CONTRACT_LINE_ID" "OKE_CONTRACT_LINE_ID", "A86"."OKE_CONTRACT_DELIVERABLE_ID" "OKE_CONTRACT_DELIVERABLE_ID", "A86"."DESTINATION_CONTEXT" "DESTINATION_CONTEXT", "A86"."DISTRIBUTION_NUM" "DISTRIBUTION_NUM", "A86"."SOURCE_DISTRIBUTION_ID" "SOURCE_DISTRIBUTION_ID", "A86"."REQUEST_ID" "REQUEST_ID", "A86"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A86"."PROGRAM_ID" "PROGRAM_ID", "A86"."CHARGE_ACCOUNT
" "CHARGE_ACCOUNT", "A86"."FULL_NAME" "FULL_NAME", "A86"."WORK_TELEPHONE" "WORK_TELEPHONE", "A86"."EMAIL_ADDRESS" "EMAIL_ADDRESS", "A86"."REQUESTER_DELIVER_FIRST_NAME" "REQUESTER_DELIVER_FIRST_NAME", "A86"."REQUESTER_DELIVER_LAST_NAME" "REQUESTER_DELIVER_LAST_NAME", "A86"."REQUESTER_DELIVER_TITLE" "REQUESTER_DELIVER_TITLE", "A86"."QUANTITY_FINANCED" "QUANTITY_FINANCED", "A86"."AMOUNT_FINANCED" "AMOUNT_FINANCED", "A86"."QUANTITY_RECOUPED" "QUANTITY_RECOUPED", "A86"."AMOUNT_RECOUPED" "AMOUNT_RECOUPED", "A86"."RETAINAGE_WITHHELD_AMOUNT" "RETAINAGE_WITHHELD_AMOUNT", "A86"."RETAINAGE_RELEASED_AMOUNT" "RETAINAGE_RELEASED_AMOUNT" FROM "PO_DISTRIBUTION_XML" "A86" WHERE "A86"."PO_HEADER_ID"=:CV1$ AND "A86"."LINE_LOCATION_ID"="A32"."LINE_LOCATION_ID") "DISTRIBUTIONS" FROM "PO_LINE_LOCATIONS_XML" "A32" WHERE "A32"."PO_LINE_ID"="A2"."PO_LINE_ID" AND NVL("A32"."PAYMENT_TYPE", 'NONE')<>'ADVANCE' AND NVL("A32"."PAYMENT_TYPE", 'NONE')<>'DELIVERY') "LINE_LOCATIONS" FROM "PO_LINES_XML" "A2" WHERE "A2"."PO_HEADER_ID"=:CV1$ |
| 85gad38y8bvv3 | begin :1 :=PO_COMMUNICATION_PVT.POXMLGEN( :2, :3, :4, :5, :6, :7, :8, :9); end; |
| 8w57t3xaxs89k | SELECT NAME, VERSION FROM FND_CACHE_VERSIONS |
| 9tssyu6p7uk2s | SELECT SUM(AID.AMOUNT) FROM AP_INVOICE_DISTRIBUTIONS AID, AP_INVOICE_LINES AIL WHERE AID.INVOICE_ID = :B2 AND AID.INVOICE_LINE_NUMBER = :B1 AND AIL.INVOICE_ID = AID.INVOICE_ID AND AIL.LINE_NUMBER = AID.INVOICE_LINE_NUMBER AND AIL.LINE_TYPE_LOOKUP_CODE IN ('ITEM', 'RETAINAGE RELEASE') AND AID.PARENT_REVERSAL_ID IS NULL AND (AID.LINE_TYPE_LOOKUP_CODE = 'PREPAY' OR (AID.LINE_TYPE_LOOKUP_CODE IN ('REC_TAX', 'NONREC_TAX') AND AID.PREPAY_DISTRIBUTION_ID IS NOT NULL) OR (AID.LINE_TYPE_LOOKUP_CODE IN ('TIPV', 'TRV', 'TERV') AND AID.RELATED_ID IN (SELECT INVOICE_DISTRIBUTION_ID FROM AP_INVOICE_DISTRIBUTIONS AID1 WHERE AID1.INVOICE_ID = AID.INVOICE_ID AND AID1.INVOICE_LINE_NUMBER = AID.INVOICE_LINE_NUMBER AND AID1.LINE_TYPE_LOOKUP_CODE IN ('REC_TAX', 'NONREC_TAX') AND AID1.PREPAY_DISTRIBUTION_ID IS NOT NULL) ) ) |
| 9ybx57rqdhm4m | BEGIN PO_INTERFACE_S.create_documents( p_api_version => 1.0, x_return_status => :1, x_msg_count => :2, x_msg_data => :3, p_batch_id => :4, p_req_operating_unit_id => :5, p_purch_operating_unit_id => :6, x_document_id => :7, x_number_lines => :8, x_document_number => :9, p_document_creation_method => 'AUTOCREATE'); END; |
| a4gss3ajbyfzr | SELECT R.RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL R WHERE R.RESPONSIBILITY_ID = :B2 AND R.APPLICATION_ID = :B1 |
| aaw4na3kmdfkq | DECLARE l_result varchar2(1); BEGIN l_result := FND_AOLJ_UTIL.convertGuestSession(:1, :2, :3, :4, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20); :21 := l_result;END; |
| akma8kaxsp84b |
SELECT reservation_id , requirement_date , organization_id , inventory_item_id , demand_source_type_id , demand_source_name , demand_source_header_id , demand_source_line_id , demand_source_delivery , primary_uom_code , primary_uom_id , secondary_uom_code , secondary_uom_id , reservation_uom_code , reservation_uom_id , reservation_quantity , primary_reservation_quantity , secondary_reservation_quantity , detailed_quantity , secondary_detailed_quantity , autodetail_group_id , external_source_code , external_source_line_id , supply_source_type_id , supply_source_header_id , supply_source_line_id , supply_source_name , supply_source_line_detail , revision , subinventory_code , subinventory_id , locator_id , lot_number , lot_number_id , pick_slip_number , lpn_id , attribute_category , attribute1 , attribute2 , attribute3 , attribute4 , attribute5 , attribute6 , attribute7 , attribute8 , attribute9 , attribute10 , attribute11 , attribute12 , attribute13 , attribute14 , attribute15 , ship_ready_flag , staged_flag /**** {{ R12 Enhanced reservations code changes }}****/ , crossdock_flag , crossdock_criteria_id , demand_source_line_detail , serial_reservation_quantity , supply_receipt_date , demand_ship_date , project_id , task_id , orig_supply_source_type_id , orig_supply_source_header_id , orig_supply_source_line_id , orig_supply_source_line_detail , orig_demand_source_type_id , orig_demand_source_header_id , orig_demand_source_line_id , orig_demand_source_line_detail , serial_number /***** End R12 ***/ FROM mtl_reservations WHERE (:requirement_date = :l_miss_date OR :requirement_date IS NULL AND requirement_date IS NULL OR :requirement_date = requirement_date ) AND (:organization_id = :l_miss_num OR :organization_id IS NULL AND organization_id IS NULL OR :organization_id = organization_id ) AND (:inventory_item_id = :l_miss_num OR :inventory_item_id IS NULL AND inventory_item_id IS NULL OR :inventory_item_id = inventory_item_id ) AND (:demand_source_type_id = :l_miss_num OR :demand_source_type_id IS NULL AND demand_source_type_id IS NULL OR :demand_source_type_id = demand_source_type_id ) AND (:demand_source_header_id = :l_miss_num OR :demand_source_header_id IS NULL AND demand_source_header_id IS NULL OR :demand_source_header_id = demand_source_header_id ) AND (:demand_source_line_id = :l_miss_num OR :demand_source_line_id IS NULL AND demand_source_line_id IS NULL OR :demand_source_line_id = demand_source_line_id ) AND (:demand_source_name = :l_miss_char OR :demand_source_name IS NULL AND demand_source_name IS NULL OR :demand_source_name = demand_source_name ) AND (:demand_source_delivery = :l_miss_num OR :demand_source_delivery IS NULL AND demand_source_delivery IS NULL OR :demand_source_delivery = demand_source_delivery ) AND (:primary_uom_code = :l_miss_char OR :primary_uom_code IS NULL AND primary_uom_code IS NULL OR :primary_uom_code = primary_uom_code ) AND (:primary_uom_id = :l_miss_num OR :primary_uom_id IS NULL AND primary_uom_id IS NULL OR :primary_uom_id = primary_uom_id ) -- INVCONV BEGIN AND (:secondary_uom_code = :l_miss_char OR :secondary_uom_code IS NULL AND secondary_uom_code IS NULL OR :secondary_uom_code = secondary_uom_code ) AND (:secondary_uom_id = :l_miss_num OR :secondary_uom_id IS NULL AND secondary_uom_id IS NULL OR :secondary_uom_id = secondary_uom_id ) -- INVCONV END AND (:reservation_uom_code = :l_miss_char OR :reservation_uom_code IS NULL AND reservation_uom_code IS NULL OR :reservation_uom_code = reservation_uom_code ) AND (:reservation_uom_id = :l_miss_num OR :reservation_uom_id IS NULL AND reservation_uom_id IS NULL OR :reservation_uom_id = reservation_uom_id ) AND (:autodetail_group_id = :l_miss_num OR :autodetail_group_id IS NULL AND autodetail_group_id IS NULL OR :autodetail_group_id = autodetail_group_id ) AND (:external_source_code = :l_miss_char OR :external_source_code IS NULL AND external_source_code IS NULL OR :external_s
ource_code = external_source_code ) AND (:external_source_line_id = :l_miss_num OR :external_source_line_id IS NULL AND external_source_line_id IS NULL OR :external_source_line_id = external_source_line_id ) AND (:supply_source_type_id = :l_miss_num OR :supply_source_type_id IS NULL AND supply_source_type_id IS NULL OR :supply_source_type_id = supply_source_type_id ) AND (:supply_source_header_id = :l_miss_num OR :supply_source_header_id IS NULL AND supply_source_header_id IS NULL OR :supply_source_header_id = supply_source_header_id ) AND (:supply_source_line_id = :l_miss_num OR :supply_source_line_id IS NULL AND supply_source_line_id IS NULL OR :supply_source_line_id = supply_source_line_id ) AND (:supply_source_name = :l_miss_char OR :supply_source_name IS NULL AND supply_source_name IS NULL OR :supply_source_name = supply_source_name ) AND (:supply_source_line_detail = :l_miss_num OR :supply_source_line_detail IS NULL AND supply_source_line_detail IS NULL OR :supply_source_line_detail = supply_source_line_detail ) AND (:revision = :l_miss_char OR :revision IS NULL AND revision IS NULL OR :revision = revision ) AND (:subinventory_code = :l_miss_char OR :subinventory_code IS NULL AND subinventory_code IS NULL OR :subinventory_code = subinventory_code ) AND (:subinventory_id = :l_miss_num OR :subinventory_id IS NULL AND subinventory_id IS NULL OR :subinventory_id = subinventory_id ) AND (:locator_id = :l_miss_num OR :locator_id IS NULL AND locator_id IS NULL OR :locator_id = locator_id ) AND (:lot_number = :l_miss_char OR :lot_number IS NULL AND lot_number IS NULL OR :lot_number = lot_number ) AND (:lot_number_id = :l_miss_num OR :lot_number_id IS NULL AND lot_number_id IS NULL OR :lot_number_id = lot_number_id ) AND (:lpn_id = :l_miss_num OR :lpn_id IS NULL AND lpn_id IS NULL OR :lpn_id = lpn_id ) AND (:ship_ready_flag = :l_miss_num OR (:ship_ready_flag IS NULL OR :ship_ready_flag = 2) AND (ship_ready_flag IS NULL OR ship_ready_flag = 2) OR :ship_ready_flag = ship_ready_flag ) AND (:staged_flag = :l_miss_char OR (:staged_flag IS NULL OR :staged_flag = 'N') AND (staged_flag IS NULL OR staged_flag = 'N') OR :staged_flag = staged_flag ) AND (:attribute_category = :l_miss_char OR :attribute_category IS NULL AND attribute_category IS NULL OR :attribute_category = attribute_category ) AND (:attribute1 = :l_miss_char OR :attribute1 IS NULL AND attribute1 IS NULL OR :attribute1 = attribute1 ) AND (:attribute2 = :l_miss_char OR :attribute2 IS NULL AND attribute2 IS NULL OR :attribute2 = attribute2 ) AND (:attribute3 = :l_miss_char OR :attribute3 IS NULL AND attribute3 IS NULL OR :attribute3 = attribute3 ) AND (:attribute4 = :l_miss_char OR :attribute4 IS NULL AND attribute4 IS NULL OR :attribute4 = attribute4 ) AND (:attribute5 = :l_miss_char OR :attribute5 IS NULL AND attribute5 IS NULL OR :attribute5 = attribute5 ) AND (:attribute6 = :l_miss_char OR :attribute6 IS NULL AND attribute6 IS NULL OR :attribute6 = attribute6 ) AND (:attribute7 = :l_miss_char OR :attribute7 IS NULL AND attribute7 IS NULL OR :attribute7 = attribute7 ) AND (:attribute8 = :l_miss_char OR :attribute8 IS NULL AND attribute8 IS NULL OR :attribute8 = attribute8 ) AND (:attribute9 = :l_miss_char OR :attribute9 IS NULL AND attribute9 IS NULL OR :attribute9 = attribute9 ) AND (:attribute10 = :l_miss_char OR :attribute10 IS NULL AND attribute10 IS NULL OR :attribute10 = attribute10 ) AND (:attribute11 = :l_miss_char OR :attribute11 IS NULL AND attribute11 IS NULL OR :attribute11 = attribute11 ) AND (:attribute12 = :l_miss_char OR :attribute12 IS NULL AND attribute12 IS NULL OR :attribute12 = attribute12 ) AND (:attribute13 = :l_miss_char OR :attribute13 IS NULL AND attribute13 IS NULL OR :attribute13 = attribute13 ) AND (:attribute14 = :l_miss_char OR :attribute14 IS NULL AND attribute14 IS NULL OR :attribute14 = attribute14 ) AND (:attribute15 = :l_miss_char OR :attribute15 IS NULL AND attribute15 IS NULL OR :attribute15 = attribute15 ) /**** {{ R12 Enhanced reserv
ations code changes }}****/ AND (:crossdock_flag = :l_miss_char OR :crossdock_flag IS NULL AND crossdock_flag IS NULL OR :crossdock_flag = crossdock_flag ) AND (:crossdock_criteria_id = :l_miss_num OR :crossdock_criteria_id IS NULL AND crossdock_criteria_id IS NULL OR :crossdock_criteria_id = crossdock_criteria_id ) AND (:demand_source_line_detail = :l_miss_num OR :demand_source_line_detail IS NULL AND demand_source_line_detail IS NULL OR :demand_source_line_detail = demand_source_line_detail ) AND (:supply_receipt_date = :l_miss_date OR :supply_receipt_date IS NULL AND supply_receipt_date IS NULL OR :supply_receipt_date = supply_receipt_date ) AND (:demand_ship_date = :l_miss_date OR :demand_ship_date IS NULL AND demand_ship_date IS NULL OR :demand_ship_date = demand_ship_date ) AND (:project_id = :l_miss_num OR :project_id IS NULL AND project_id IS NULL OR :project_id = project_id ) AND (:task_id = :l_miss_num OR :task_id IS NULL AND task_id IS NULL OR :task_id = task_id ) /***** End R12 ***/ ORDER BY NVL(DEMAND_SHIP_DATE, REQUIREMENT_DATE) ASC |
| bbugagurwv1vy | (SELECT STATUS_FLAG FROM IGI_GCC_INSTALLED_OPTIONS WHERE OPTION_NAME = UPPER(:B1 )) |
| bqf04xkudk4zt | BEGIN :1 := FND_AOLJ_UTIL.createSession(:2, :3, :4, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22);:23 := fnd_session_management.g_enc_key;:24 := fnd_session_management.g_mac_key;END; |
| bw5t54n7fjk02 | SELECT INVENTORY_ORGANIZATION_ID FROM FINANCIALS_SYSTEM_PARAMETERS |
| ccprbqfuu8wb1 | SELECT NUMBER_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1 |
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| ctnvq3qjh4065 | begin :1 := por_util_pkg.interface_START_WORKFLOW( :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102); end; |
| dnx99s71vmu3r | SELECT POA.AGENT_ID FROM PO_AGENTS POA, MTL_ITEM_CATEGORIES MIC WHERE MIC.INVENTORY_ITEM_ID=:B2 AND MIC.CATEGORY_ID=POA.CATEGORY_ID AND MIC.ORGANIZATION_ID=:B1 AND MIC.CATEGORY_SET_ID=(SELECT CATEGORY_SET_ID FROM MTL_DEFAULT_SETS_VIEW WHERE FUNCTIONAL_AREA_ID = 2) |
| fc1vzazaaduns |
SELECT phx.*, PO_COMMUNICATION_PVT.getIsComplexWorkPO() is_complex_work_po, PO_COMMUNICATION_PVT.getDocumentType() document_type, PO_COMMUNICATION_PVT.getCoverMessage() cover_message, PO_COMMUNICATION_PVT.getTimezone() timezone, PO_COMMUNICATION_PVT.getAmendmentMessage() ammendment_message, PO_COMMUNICATION_PVT.getTestFlag() test_flag, PO_COMMUNICATION_PVT.getDistinctShipmentCount() DIST_SHIPMENT_COUNT, PO_COMMUNICATION_PVT.getDocumentName() document_name, PO_COMMUNICATION_PVT.IsDocumentSigned(PO_COMMUNICATION_PVT.getDocumentId()) Signed, fnd_profile.value('PO_GENERATE_AMENDMENT_DOCS') amendment_profile, PO_COMMUNICATION_PVT.getWithTerms() With_Terms , PO_COMMUNICATION_PVT.getIsContractAttachedDoc() Is_Attached_Doc , CURSOR (SELECT message_name message, message_text text FROM fnd_new_messages WHERE message_name in ( 'PO_WF_NOTIF_REVISION', 'PO_WF_NOTIF_VENDOR_NO', 'PO_WF_NOTIF_PAYMENT_TERMS', 'PO_WF_NOTIF_FREIGHT_TERMS', 'PO_WF_NOTIF_FOB', 'PO_WF_NOTIF_SHIP_VIA', 'PO_WF_NOTIF_CONFIRM_TO_TELE', 'PO_WF_NOTIF_REQUESTER_DELIVER', 'PO_WF_NOTIF_DESCRIPTION', 'PO_WF_NOTIF_TAX', 'PO_WF_NOTIF_UOM', 'PO_WF_NOTIF_UNIT_PRICE', 'PO_WF_NOTIF_QUANTITY', 'PO_WF_NOTIF_PURCHASE_ORDER', 'PO_WF_NOTIF_BUYER', 'PO_WF_NOTIF_AMOUNT', 'PO_WF_NOTIF_EFFECTIVE_DATE', 'PO_WF_NOTIF_HEADER_NOTE', 'PO_WF_NOTIF_LINE_NUMBER', 'PO_WF_NOTIF_LINE_PAYITEM_NUM', -- <Complex Work R12> 'PO_WF_NOTIF_MULTIPLE', 'PO_WF_NOTIF_PART_NO_DESC', 'PO_WF_NOTIF_SUPPLIER_ITEM', 'PO_WF_NOTIF_TOTAL', 'PO_WF_NOTIF_NOTE', 'PO_FO_PACKING_INSTRUCTION', 'PO_FO_CUST_PO_NUMBER', 'PO_FO_CUST_ITEM_DESC', 'PO_FO_LINE_NUMBER', 'PO_FO_SHIP_NUMBER', 'PO_FO_AMOUNT_BASED', 'PO_FO_CONTRACTOR_NAME', 'PO_FO_START_DATE', 'PO_FO_END_DATE', 'PO_FO_WORK_SCHEDULE', 'PO_FO_SHIFT_PATTERN', 'PO_FO_PRICE_DIFFERENTIALS', 'PO_FO_DELIVER_TO_LOCATION', 'PO_FO_EFFECTIVE_START_DATE', 'PO_FO_AMOUNT_AGREED', 'PO_FO_ADVANCE', -- <Complex Work R12> 'PO_FO_RETAINAGE_RATE', -- <Complex Work R12> 'PO_FO_MAX_RETAINAGE_AMOUNT', -- <Complex Work R12> 'PO_FO_PROGRESS_PAYMENT_RATE', -- <Complex Work R12> 'PO_FO_RECOUPMENT_RATE', -- <Complex Work R12> 'PO_FO_PRICE_BREAK', 'PO_FO_CHARGE_ACCOUNT', 'PO_FO_CONTRACTOR', 'PO_FO_CONTACT_NAME', 'PO_FO_TELEPHONE', 'PO_FO_FAX', 'PO_FO_NAME', 'PO_FO_TITLE', 'PO_FO_DATE', 'PO_FO_REVISION', 'PO_FO_AMENDMENT', 'PO_FO_SHIP_METHOD', 'PO_FO_SHIPPING_INSTRUCTION', 'PO_FO_DRAFT', 'PO_FO_PROPRIETARY_INFORMATION', 'PO_FO_TRANSPORTAION_ARRANGED', 'PO_FO_DELIVER_TO_LOCATION', 'PO_FO_NO', 'PO_FO_COMPANY', 'PO_FO_SUBMIT_RESPONSE', 'PO_FO_EMAIL', 'PO_WF_NOTIF_EXPIRES_ON', 'PO_FO_TEST', 'PO_FO_ORG_AGR_ASS', 'PO_FO_EFFECTIVE_END_DATE', 'PO_FO_PURCHASING_ORGANIZATION', 'PO_FO_PURCHASING_SUPPLIER_SITE', 'PO_FO_TRANSPORTATION_ARRANGED', 'PO_WF_NOTIF_ADDRESS', 'PO_WF_NOTIF_ORDER', 'PO_WF_NOTIF_ORDER_DATE', 'PO_FO_VENDOR', 'PO_FO_SHIP_TO', 'PO_FO_BILL_TO', 'PO_FO_CONFIRM_NOT_DUPLICATE', 'PO_FO_AGREEMENT_CANCELED', 'PO_FO_FORMAL_ACCEPT', 'PO_FO_TYPE', 'PO_FO_REVISION_DATE', 'PO_FO_REVISED_BY', 'PO_FO_PRICES_EXPRESSED', 'PO_FO_NOTES', 'PO_WF_NOTIF_PREPARER', 'PO_FO_SUPPLIER_CONFIGURATION', 'PO_FO_DELIVER_DATE_TIME', 'PO_FO_LINE_REF_BPA', 'PO_FO_LINE_REF_CONTRACT', 'PO_FO_LINE_SUPPLIER_QUOTATION', 'PO_FO_USE_SHIP_ADDRESS_TOP', 'PO_FO_LINE_CANCELED', 'PO_FO_ORIGINAL_QTY_ORDERED', 'PO_FO_QUANTITY_CANCELED', 'PO_FO_SHIPMENT_CANCELED', 'PO_FO_ORIGINAL_SHIPMENT_QTY', 'PO_FO_CUSTOMER_ACCOUNT_NO', 'PO_FO_RELEASE_CANCELED', 'PO_FO_PO_CANCELED', 'PO_FO_TOTAL', 'PO_FO_SUPPLIER_ITEM', 'PO_FO_ORIGINAL_AMOUNT_ORDERED', 'PO_FO_AMOUNT_CANCELED', 'PO_FO_UN_NUMBER', 'PO_WF_NOTIF_PROMISED_DATE', 'PO_WF_NOTIF_NEEDBY_DATE', 'PO_FO_HAZARD_CLASS', 'PO_FO_PAGE', 'PO_FO_REFERENCE_DOCUMENTS', 'PO_FO_PAYITEM_CANCELED', --<Bug#: 4899200> 'PO_FO_ORIGINAL_PAYITEM_QTY', --<Bug#: 4899200> 'PO_FO_PAYITEM_QTY_CANCELED', --<Bug#: 4899200> 'PO_FO_ORIGINAL_PAYITEM_AMT',
--<Bug#: 5464968> 'PO_FO_MODIFIER_TYPE', --Enhanced Pricing 'PO_FO_BLANKET', --Enhanced Pricing 'PO_FO_BLANKET_PRICE_STRUCT', --Enhanced Pricing 'PO_FO_MODIFIER_DESC', --Enhanced Pricing 'PO_FO_RATE', --Enhanced Pricing 'PO_FO_ADJUSTED_AMT', --Enhanced Pricing 'PO_FO_RATE_APP_METHOD', --Enhanced Pricing 'PO_FO_LIST_LINE_PRICE', --Enhanced Pricing 'PO_FO_PAYITEM_AMT_CANCELED' --<Bug#: 5464968> ) AND application_id = 201 AND language_code = 'US') AS message, CURSOR( SELECT fds.short_text FROM fnd_attached_docs_form_vl fad, fnd_documents_short_text fds WHERE ((entity_name = 'PO_HEADERS' AND pk1_value = to_char(phx.po_header_id)) OR (entity_name = 'PO_VENDORS' AND pk1_value = to_char(phx.vendor_id)) OR (entity_name = 'PO_VENDOR_SITES' AND pk1_value = to_char(phx.vendor_site_id))) AND -- bug6154354 function_name = 'PO_PRINTPO' AND fad.media_id = fds.media_id AND fad.datatype_id=1 order by fad.seq_num) AS header_short_text, CURSOR( SELECT fad.url web_page --Bug#4958642 FROM fnd_attached_docs_form_vl fad WHERE ((fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(phx.po_header_id)) OR (fad.entity_name='PO_VENDORS' AND fad.pk1_value=to_char(phx.vendor_id)) OR (fad.entity_name='PO_VENDOR_SITES' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354 ) AND fad.datatype_id=5 AND fad.function_name='PO_PRINTPO' order by fad.entity_name, fad.seq_num) AS header_url_attachments, CURSOR( SELECT fad.file_name FROM fnd_attached_docs_form_vl fad WHERE ((fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(phx.po_header_id)) OR (fad.entity_name='PO_VENDORS' AND fad.pk1_value=to_char(phx.vendor_id)) OR (fad.entity_name='PO_VENDOR_SITES' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354 ) AND fad.datatype_id=6 AND fad.function_name='PO_PRINTPO' order by fad.entity_name, fad.seq_num) AS header_file_attachments, CURSOR(SELECT plx.*, CURSOR(SELECT PRICE_TYPE_DSP PRICE_TYPE, MULTIPLIER FROM po_price_differentials_v WHERE entity_type='PO LINE' AND entity_id = plx.po_line_id and enabled_flag='Y') AS price_diff, CURSOR( SELECT plx.po_line_id , fds.short_text FROM fnd_attached_docs_form_vl fad, fnd_documents_short_text fds WHERE ((fad.entity_name='PO_LINES' AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name='MTL_SYSTEM_ITEMS' AND fad.pk1_value=to_char(PO_COMMUNICATION_PVT.getInventoryOrgId()) AND --Bug6139548 fad.pk2_value=to_char(plx.item_id) AND plx.item_id is not null) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name='PO_IN_GA_LINES' AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.CONTRACT_ID) AND plx.CONTRACT_ID IS NOT NULL) ) AND function_name = 'PO_PRINTPO' AND fad.media_id = fds.media_id AND fad.datatype_id=1 order by fad.seq_num) AS line_short_text, CURSOR (SELECT pax1.* FROM PO_PRICE_ADJUSTMENTS_XML pax1 WHERE pax1.po_header_id = plx.po_header_id AND pax1.po_line_id = plx.po_line_id AND pax1.parent_adjustment_id is null order by pax1.pricing_group_sequence) AS PRICE_MODIFIERS, CURSOR (SELECT pax2.* FROM PO_PRICE_ADJUSTMENTS_XML pax2 WHERE pax2.po_header_id = plx.from_header_id AND pax2.po_line_id = plx.from_line_id AND pax2.parent_adjustment_id is null order by pax2.pricing_group_sequence) AS ADD_PRICE_MODIFIERS, CURSOR (SELECT pha.segment1 ponum FROM po_headers_all pha WHERE pha.po_header_id = plx.from_header_id) AS ADD_PRICE_PONUM, CURSOR( SELECT fad.url web_page --Bug#4958642 FROM fnd_attached_docs_form_vl fad WHERE ((fad.entity_name='PO_LINES' AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name='PO_IN_GA_LINES' AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.contract_id) AND plx.contract_id IS NO
T NULL) OR (fad.entity_name='MTL_SYSTEM_ITEMS' AND fad.pk1_value=to_char(PO_COMMUNICATION_PVT.getInventoryOrgId()) AND fad.pk2_value=to_char(plx.item_id) AND plx.item_id is not null) ) AND fad.datatype_id=5 AND fad.function_name='PO_PRINTPO' order by fad.seq_num) AS line_url_attachments, CURSOR( SELECT fad.file_name FROM fnd_attached_docs_form_vl fad WHERE ((fad.entity_name='PO_LINES' AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name='PO_IN_GA_LINES' AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name='PO_HEADERS' AND fad.pk1_value=to_char(plx.contract_id) AND plx.contract_id IS NOT NULL) OR (fad.entity_name='MTL_SYSTEM_ITEMS' AND fad.pk1_value=to_char(PO_COMMUNICATION_PVT.getInventoryOrgId()) AND fad.pk2_value=to_char(plx.item_id) AND plx.item_id is not null) ) AND fad.datatype_id=6 AND fad.function_name='PO_PRINTPO' order by fad.seq_num) AS line_file_attachments, CURSOR(SELECT pllx.*, CURSOR( SELECT pllx.line_location_id, fds.short_text FROM fnd_attached_docs_form_vl fad, fnd_documents_short_text fds WHERE entity_name = 'PO_SHIPMENTS' AND pk1_value = to_char(pllx.line_location_id) AND function_name = 'PO_PRINTPO' AND fad.media_id = fds.media_id AND fad.datatype_id=1 order by fad.seq_num) AS line_loc_short_text, CURSOR( SELECT fad.url web_page --Bug#4958642 FROM fnd_attached_docs_form_vl fad WHERE fad.entity_name='PO_SHIPMENTS' AND fad.pk1_value=to_char(pllx.line_location_id) AND fad.datatype_id=5 AND fad.function_name='PO_PRINTPO' order by fad.seq_num ) AS line_loc_url_attachments, CURSOR( SELECT fad.file_name FROM fnd_attached_docs_form_vl fad WHERE fad.entity_name='PO_SHIPMENTS' AND fad.pk1_value=to_char(pllx.line_location_id) AND fad.datatype_id=6 AND fad.function_name='PO_PRINTPO' order by fad.seq_num) AS line_loc_file_attachments, CURSOR(SELECT pdx.* FROM po_distribution_xml pdx WHERE pdx.po_header_id = phx.po_header_id and pdx.LINE_LOCATION_ID = pllx.LINE_LOCATION_ID) AS distributions FROM po_line_locations_xml pllx WHERE pllx.po_line_id = plx.po_line_id AND NVL(pllx.payment_type, 'NONE') NOT IN ('ADVANCE', 'DELIVERY') ) AS line_locations FROM po_lines_xml plx WHERE plx.po_header_id = phx.po_header_id ) AS lines FROM PO_HEADERS_XML phx WHERE phx.PO_HEADER_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum() |
| fjvwzpxbpch0h | /* OracleOEM */ select capture_name streams_name, 'capture' streams_type , (available_message_create_time- capture_message_create_time)*86400 latency, nvl(total_messages_enqueued, 0) total_messages from gv$streams_capture union all select propagation_name streams_name, 'propagation' streams_type, last_lcr_latency latency , total_msgs total_messages from gv$propagation_sender where propagation_name is not null union all select server_name streams_name, 'apply' streams_type, (send_time-last_sent_message_create_time)*86400 latency, nvl(total_messages_sent, 0) total_messages from gv$xstream_outbound_server where committed_data_only='NO' union all SELECT distinct apc.apply_name as STREAMS_NAME, 'apply' as STREAMS_TYPE, CASE WHEN aps.state != 'IDLE' THEN nvl((aps.apply_time - aps.create_time)*86400, -1) WHEN apc.state != 'IDLE' THEN nvl((apc.apply_time - apc.create_time)*86400, -1) WHEN apr.state != 'IDLE' THEN nvl((apr.apply_time - apr.create_time)*86400, -1) ELSE 0 END as STREAMS_LATENCY, nvl(aps.TOTAL_MESSAGES_APPLIED, 0) as TOTAL_MESSAGES FROM ( SELECT apply_name, state, apply_time, applied_message_create_time as create_time, total_messages_applied FROM ( SELECT apply_name, state, apply_time, applied_message_create_time, MAX(applied_message_create_time) OVER (PARTITION BY apply_name) as max_create_time, SUM(total_messages_applied) OVER (PARTITION BY apply_name) as total_messages_applied FROM gv$streams_apply_server ) WHERE MAX_CREATE_TIME||'X' = APPLIED_MESSAGE_CREATE_TIME||'X' ) aps, ( SELECT c.apply_name, state, -- This is the XOUT case c.hwm_time as apply_time, hwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name in (select server_name from dba_xstream_outbound) union SELECT c.apply_name, state, -- This is non-XOUT case c.lwm_time as apply_time, lwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name not in (select server_name from dba_xstream_outbound) ) apc, ( SELECT apply_name, state, dequeue_time as apply_time, dequeued_message_create_time as create_time FROM gv$streams_apply_reader ) apr WHERE apc.apply_name = apr.apply_name AND apr.apply_name = aps.apply_name |
| g4pktka6kg4w9 | SELECT MENU_ID, ENTRY_SEQUENCE, FUNCTION_ID, SUB_MENU_ID, GRANT_FLAG FROM FND_MENU_ENTRIES WHERE MENU_ID = :B1 |
| g89s7tq651bus |
INSERT INTO ZX_TRANSACTION_LINES_GT( APPLICATION_ID , ENTITY_CODE , EVENT_CLASS_CODE , TRX_ID , TRX_LEVEL_TYPE , TRX_LINE_ID , LINE_LEVEL_ACTION , LINE_CLASS , TRX_LINE_TYPE , TRX_LINE_DATE , TRX_BUSINESS_CATEGORY , LINE_INTENDED_USE , USER_DEFINED_FISC_CLASS , LINE_AMT , TRX_LINE_QUANTITY , PRODUCT_ID , PRODUCT_ORG_ID , PRODUCT_FISC_CLASSIFICATION , UOM_CODE , PRODUCT_TYPE , PRODUCT_CODE , PRODUCT_CATEGORY , FOB_POINT , SHIP_FROM_PARTY_ID , BILL_FROM_PARTY_ID , SHIP_FROM_PARTY_SITE_ID , BILL_FROM_PARTY_SITE_ID , SHIP_TO_LOCATION_ID , SHIP_FROM_LOCATION_ID , BILL_TO_LOCATION_ID , BILL_FROM_LOCATION_ID , ACCOUNT_CCID , REF_DOC_APPLICATION_ID , REF_DOC_ENTITY_CODE , REF_DOC_EVENT_CLASS_CODE , REF_DOC_TRX_ID , REF_DOC_LINE_ID , LINE_TRX_USER_KEY1 , LINE_TRX_USER_KEY2 , LINE_TRX_USER_KEY3 , TRX_LINE_NUMBER , TRX_LINE_DESCRIPTION , PRODUCT_DESCRIPTION , ASSESSABLE_VALUE , LINE_AMT_INCLUDES_TAX_FLAG , INPUT_TAX_CLASSIFICATION_CODE , SOURCE_APPLICATION_ID , SOURCE_ENTITY_CODE , SOURCE_EVENT_CLASS_CODE , SOURCE_TRX_ID , SOURCE_LINE_ID , SOURCE_TRX_LEVEL_TYPE , UNIT_PRICE , REF_DOC_TRX_LEVEL_TYPE , SHIP_THIRD_PTY_ACCT_ID , BILL_THIRD_PTY_ACCT_ID , SHIP_THIRD_PTY_ACCT_SITE_ID , BILL_THIRD_PTY_ACCT_SITE_ID , SHIP_TO_PARTY_ID , USER_UPD_DET_FACTORS_FLAG , DEFAULTING_ATTRIBUTE1 ) SELECT :B5 , :B4 , :B3 , PH.PO_HEADER_ID , :B2 , PLL.LINE_LOCATION_ID , PLL.TAX_ATTRIBUTE_UPDATE_CODE , DECODE(PLL.SHIPMENT_TYPE, 'PREPAYMENT', DECODE(PLL.PAYMENT_TYPE, 'ADVANCE', 'ADVANCE', 'FINANCING'), DECODE(PLL.VALUE_BASIS, 'QUANTITY', 'INVOICE', 'AMOUNT') ) , 'ITEM' , COALESCE(PLL.NEED_BY_DATE, PLL.PROMISED_DATE, SYSDATE) , DECODE(:B7 , 'COPY_DOCUMENT', NULL, ZXLDET.TRX_BUSINESS_CATEGORY) , DECODE(:B7 , 'COPY_DOCUMENT', NULL, ZXLDET.LINE_INTENDED_USE) , DECODE(:B7 , 'COPY_DOCUMENT', NULL, ZXLDET.USER_DEFINED_FISC_CLASS) , NVL(PLL.AMOUNT, PLL.PRICE_OVERRIDE*PLL.QUANTITY) , PLL.QUANTITY , PL.ITEM_ID , (SELECT FSP.INVENTORY_ORGANIZATION_ID FROM FINANCIALS_SYSTEM_PARAMS_ALL FSP WHERE FSP.ORG_ID=PLL.ORG_ID) , DECODE(:B7 , 'COPY_DOCUMENT', NULL, ZXLDET.PRODUCT_FISC_CLASSIFICATION) , (SELECT MUM.UOM_CODE FROM MTL_UNITS_OF_MEASURE MUM WHERE MUM.UNIT_OF_MEASURE=PLL.UNIT_MEAS_LOOKUP_CODE) , DECODE(:B7 , 'COPY_DOCUMENT', NULL, ZXLDET.PRODUCT_TYPE) , MSIB.SEGMENT1 , DECODE(:B7 , 'COPY_DOCUMENT', NULL, ZXLDET.PRODUCT_CATEGORY) , PH.FOB_LOOKUP_CODE , PV.PARTY_ID , PV.PARTY_ID , PVS.PARTY_SITE_ID , PVS.PARTY_SITE_ID , PLL.SHIP_TO_LOCATION_ID , (SELECT HZPS.LOCATION_ID FROM HZ_PARTY_SITES HZPS WHERE HZPS.PARTY_SITE_ID = PVS.PARTY_SITE_ID) , PH.BILL_TO_LOCATION_ID , (SELECT PVS.LOCATION_ID FROM PO_VENDOR_SITES_ALL PVS WHERE PVS.VENDOR_SITE_ID=PH.VENDOR_SITE_ID) , NVL((SELECT PD.CODE_COMBINATION_ID FROM PO_DISTRIBUTIONS_ALL PD WHERE PD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND ROWNUM = 1), MSIB.EXPENSE_ACCOUNT ) , NULL , NULL , NULL , NULL , NULL , PL.LINE_NUM , PO_LOCATIONS_S.GET_LOCATION_CODE(PLL.SHIP_TO_LOCATION_ID) , DECODE(PLL.PAYMENT_TYPE, NULL, 0, 'DELIVERY', 1, 'ADVANCE', 2, 3) , DECODE(PLL.PAYMENT_TYPE, 'ADVANCE', NULL, 'DELIVERY', NULL, PLL.SHIPMENT_NUM) , DECODE(PLL.SHIPMENT_TYPE, 'STANDARD', DECODE(PLL.PAYMENT_TYPE, NULL, PL.ITEM_DESCRIPTION, PLL.DESCRIPTION ), PL.ITEM_DESCRIPTION ) , DECODE(PLL.SHIPMENT_TYPE, 'STANDARD', DECODE(PLL.PAYMENT_TYPE, NULL, PL.ITEM_DESCRIPTION, PLL.DESCRIPTION ), PL.ITEM_DESCRIPTION ) , DECODE(:B7 , 'COPY_DOCUMENT', NULL, ZXLDET.ASSESSABLE_VALUE) , 'N' , DECODE(:B7 , 'PDOI', PLL.TAX_NAME, 'COPY_DOCUMENT', NULL, ZXLDET.INPUT_TAX_CLASSIFICATION_CODE) , DECODE(:B7 , 'COPY_DOCUMENT', :B5 , 'POXBWVRP_PO', :B5 , 'AUTOCREATED_DOC_WF' , :B5 , 'PORELGEB', :B5 , NULL) , DECODE(:B7 , 'COPY_DOCUMENT', :B4 , 'POXBWVRP_PO', :B9 , 'AUTOCREATED_DOC_WF', :B9 , 'PORELGEB', :B9 , NULL) , DECODE(:B7 , 'COPY_DOCUMENT', :B3 , 'POXBWVRP_PO', :B8 , 'AUTOCREATED_DOC_WF', :B8 , 'PORELGEB', :B8 , NULL) , DECODE(:B7 , 'COPY_DOCUMENT', (SELECT SOURCE_SHIPMENT.PO_HEADER_ID F
ROM PO_LINE_LOCATIONS_ALL SOURCE_SHIPMENT WHERE SOURCE_SHIPMENT.LINE_LOCATION_ID = PLL.ORIGINAL_SHIPMENT_ID AND :B7 = 'COPY_DOCUMENT'), 'POXBWVRP_PO', (SELECT REQUISITION_HEADER_ID FROM PO_REQUISITION_LINES_ALL WHERE REQUISITION_LINE_ID IN (SELECT MIN(REQUISITION_LINE_ID) FROM PO_REQUISITION_LINES_ALL PRL WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID) AND :B7 = 'POXBWVRP_PO'), 'AUTOCREATED_DOC_WF', (SELECT REQUISITION_HEADER_ID FROM PO_REQUISITION_LINES_ALL WHERE REQUISITION_LINE_ID IN (SELECT MIN(REQUISITION_LINE_ID) FROM PO_REQUISITION_LINES_ALL PRL WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID) AND :B7 = 'AUTOCREATED_DOC_WF'), 'PORELGEB', (SELECT REQUISITION_HEADER_ID FROM PO_REQUISITION_LINES_ALL WHERE REQUISITION_LINE_ID IN (SELECT MIN(REQUISITION_LINE_ID) FROM PO_REQUISITION_LINES_ALL PRL WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID) AND :B7 = 'PORELGEB'), NULL) , DECODE(:B7 , 'COPY_DOCUMENT', PLL.ORIGINAL_SHIPMENT_ID, 'POXBWVRP_PO', (SELECT MIN(REQUISITION_LINE_ID) FROM PO_REQUISITION_LINES_ALL PRL WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND :B7 = 'POXBWVRP_PO'), 'AUTOCREATED_DOC_WF', (SELECT MIN(REQUISITION_LINE_ID) FROM PO_REQUISITION_LINES_ALL PRL WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND :B7 = 'AUTOCREATED_DOC_WF'), 'PORELGEB', (SELECT MIN(REQUISITION_LINE_ID) FROM PO_REQUISITION_LINES_ALL PRL WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND :B7 = 'PORELGEB'), NULL) , DECODE(:B7 , 'COPY_DOCUMENT', :B2 , 'POXBWVRP_PO', :B6 , 'AUTOCREATED_DOC_WF', :B6 , 'PORELGEB', :B6 , NULL) , PLL.PRICE_OVERRIDE , NULL , PV.VENDOR_ID , PV.VENDOR_ID , PVS.VENDOR_SITE_ID , PVS.VENDOR_SITE_ID , PLL.SHIP_TO_ORGANIZATION_ID , (SELECT 'Y' FROM DUAL WHERE :B7 = 'PDOI' AND PLL.TAX_NAME IS NOT NULL) , PLL.SHIP_TO_ORGANIZATION_ID FROM PO_HEADERS_ALL PH, PO_LINES_ALL PL, PO_LINE_LOCATIONS_ALL PLL, ZX_LINES_DET_FACTORS ZXLDET, PO_VENDORS PV, PO_VENDOR_SITES_ALL PVS, MTL_SYSTEM_ITEMS_B MSIB WHERE PH.PO_HEADER_ID = PLL.PO_HEADER_ID AND PL.PO_LINE_ID = PLL.PO_LINE_ID AND PLL.TAX_ATTRIBUTE_UPDATE_CODE IS NOT NULL AND PLL.TAX_ATTRIBUTE_UPDATE_CODE <> 'DIST_DELETE' AND PH.PO_HEADER_ID = :B1 AND ZXLDET.APPLICATION_ID(+) = :B5 AND ZXLDET.ENTITY_CODE(+) = :B4 AND ZXLDET.EVENT_CLASS_CODE(+) = :B3 AND ZXLDET.TRX_LEVEL_TYPE(+) = :B2 AND ZXLDET.TRX_LINE_ID(+) = PLL.ORIGINAL_SHIPMENT_ID AND PV.VENDOR_ID(+) = PH.VENDOR_ID AND PVS.VENDOR_SITE_ID(+) = PH.VENDOR_SITE_ID AND MSIB.INVENTORY_ITEM_ID(+) = PL.ITEM_ID AND MSIB.ORGANIZATION_ID(+) = PL.ORG_ID |
| gyxv37z6aqyqp | SELECT P.PID, P.SPID, AUDSID, PROCESS, SUBSTR(USERENV('LANGUAGE'), INSTR( USERENV('LANGUAGE'), '.') + 1) FROM V$SESSION S, V$PROCESS P WHERE P.ADDR = S.PADDR AND S.AUDSID = USERENV('SESSIONID') |