| SQL Id | SQL Text |
|---|
| 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; |
| 1f93n1zaan5x1 |
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, :"SYS_B_00", :"SYS_B_01", :"SYS_B_02") RFQ_REQUIRED , NVL(prl.rfq_required_flag, :"SYS_B_03") RFQ_REQUIRED_FLAG , NVL(prl.on_rfq_flag, :"SYS_B_04") ON_RFQ_FLAG , NVL(prl.drop_ship_flag, :"SYS_B_05") 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, :"SYS_B_06", prl.amount, :"SYS_B_07", 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, :"SYS_B_08", prl.currency_amount, :"SYS_B_09", prl.currency_amount, prl.quantity * prl.currency_unit_price) FOREIGN_CURRENCY_AMT , decode(pltb.purchase_basis, :"SYS_B_10", prl.currency_unit_price , :"SYS_B_11", decode(prl.order_type_lookup_code , :"SYS_B_12", prl.amount , :"SYS_B_13", prl.quantity * prl.currency_unit_price) , :"SYS_B_14", 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)||:"SYS_B_15"||rtrim(deliver_hz.city), :"SYS_B_16", :"SYS_B_17")) 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, :"SYS_B_18", :"SYS_B_19", :"SYS_B_20") ENCUMBERED , NVL(prl.encumbered_flag, :"SYS_B_21") 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, :"SYS_B_22")), :"SYS_B_23", :"SYS_B_24", :"SYS_B_25") LATE_FLAG , DECODE(prl.modified_by_agent_flag, :"SYS_B_26", :"SYS_B_27", :"SYS_B_28") 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, :"SYS_B_29"), :"SYS_B_30", TO_NUMBER(NULL),
:"SYS_B_31", -:"SYS_B_32", 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 REQUESTER_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, :"SYS_B_33") GLOBAL_FLAG , DECODE (src_doc.global_agreement_flag, :"SYS_B_34", :"SYS_B_35", :"SYS_B_36") GLOBAL , DECODE (prl.blanket_po_header_id, NULL, :"SYS_B_37", :"SYS_B_38") REQ_SOURCED_FLAG , prl.oke_contract_header_id OKE_CONTRACT_HEADER_ID , prl.assignment_start_date ASSIGNMENT_START_DATE , DECODE (prl.new_supplier_flag, :"SYS_B_39", :"SYS_B_40", :"SYS_B_41") NEW_SUPPLIER , NVL(prl.new_supplier_flag, :"SYS_B_42") 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, :"SYS_B_43", :"SYS_B_44") UNASSIGNED_FLAG , prl.un_number_id UN_NUMBER_ID , DECODE (prl.urgent_flag, :"SYS_B_45", :"SYS_B_46", :"SYS_B_47") URGENT , NVL(prl.urgent_flag, :"SYS_B_48") URGENT_FLAG , DECODE (prl.vmi_flag, :"SYS_B_49", :"SYS_B_50", :"SYS_B_51") VMI , NVL(prl.vmi_flag, :"SYS_B_52") VMI_FLAG , prl.wip_entity_id WIP_ENTITY_ID , prl.wip_line_id WIP_LINE_ID , NVL(prh.authorization_status, :"SYS_B_53") 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 ||:"SYS_B_54" || prl.line_num REQUEST , nvl( msi.concatenated_segments, prl.item_description) ITEM , decode(pltb.purchase_basis, :"SYS_B_55", prl.unit_price , :"SYS_B_56", decode(prl.order_type_lookup_code , :"SYS_B_57", prl.amount , :"SYS_B_58", prl.quantity * prl.unit_price) , :"SYS_B_59", prl.unit_price ) PRICE , prl.vendor_contact_id VENDOR_CONTACT_ID , prl.PARENT_REQ_LINE_ID , prl.source_type_code , ( SELECT :"SYS_B_60" FROM dual WHERE exists ( SELECT :"SYS_B_61" FROM po_req_distributions_all prd WHERE prd.requisition_line_id=prl.requisition_line_id AND prd.award_id is not null ) )AWARD_E
XISTS , 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(:"SYS_B_62") AND pltb.line_type_id = prl.line_type_id AND plttl.line_type_id = pltb.line_type_id AND plttl.language = userenv(:"SYS_B_63") 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(:"SYS_B_64") 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(:"SYS_B_65") 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 = :"SYS_B_66" AND ( NOT (pltb.order_type_lookup_code = :"SYS_B_67" AND pltb.purchase_basis = :"SYS_B_68" AND EXISTS (SELECT :"SYS_B_69" 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 = :"SYS_B_70" AND pltb.purchase_basis = :"SYS_B_71" AND EXISTS (SELECT :"SYS_B_72" 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, :"SYS_B_73") NOT IN (:"SYS_B_74", :"SYS_B_75") 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(:"SYS_B_76"), :"SYS_B_77", FND_GLOBAL.EMPLOYEE_ID, :"SYS_B_78", 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 |
| 1rd31t40r4fu5 | BEGIN fnd_global.bless_next_init('FND_PERMIT_0006'); FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END; |
| 1xhyhsq3uy5by | SELECT ACCRUED_CODE_COMBINATION_ID FROM PO_SYSTEM_PARAMETERS |
| 2vndf5psfws5a |
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, :"SYS_B_00", :"SYS_B_01", :"SYS_B_02") RFQ_REQUIRED , NVL(prl.rfq_required_flag, :"SYS_B_03") RFQ_REQUIRED_FLAG , NVL(prl.on_rfq_flag, :"SYS_B_04") ON_RFQ_FLAG , NVL(prl.drop_ship_flag, :"SYS_B_05") 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, :"SYS_B_06", prl.amount, :"SYS_B_07", 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, :"SYS_B_08", prl.currency_amount, :"SYS_B_09", prl.currency_amount, prl.quantity * prl.currency_unit_price) FOREIGN_CURRENCY_AMT , decode(pltb.purchase_basis, :"SYS_B_10", prl.currency_unit_price , :"SYS_B_11", decode(prl.order_type_lookup_code , :"SYS_B_12", prl.amount , :"SYS_B_13", prl.quantity * prl.currency_unit_price) , :"SYS_B_14", 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)||:"SYS_B_15"||rtrim(deliver_hz.city), :"SYS_B_16", :"SYS_B_17")) 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, :"SYS_B_18", :"SYS_B_19", :"SYS_B_20") ENCUMBERED , NVL(prl.encumbered_flag, :"SYS_B_21") 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, :"SYS_B_22")), :"SYS_B_23", :"SYS_B_24", :"SYS_B_25") LATE_FLAG , DECODE(prl.modified_by_agent_flag, :"SYS_B_26", :"SYS_B_27", :"SYS_B_28") 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, :"SYS_B_29"), :"SYS_B_30", TO_NUMBER(NULL),
:"SYS_B_31", -:"SYS_B_32", 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 REQUESTER_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, :"SYS_B_33") GLOBAL_FLAG , DECODE (src_doc.global_agreement_flag, :"SYS_B_34", :"SYS_B_35", :"SYS_B_36") GLOBAL , DECODE (prl.blanket_po_header_id, NULL, :"SYS_B_37", :"SYS_B_38") REQ_SOURCED_FLAG , prl.oke_contract_header_id OKE_CONTRACT_HEADER_ID , prl.assignment_start_date ASSIGNMENT_START_DATE , DECODE (prl.new_supplier_flag, :"SYS_B_39", :"SYS_B_40", :"SYS_B_41") NEW_SUPPLIER , NVL(prl.new_supplier_flag, :"SYS_B_42") 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, :"SYS_B_43", :"SYS_B_44") UNASSIGNED_FLAG , prl.un_number_id UN_NUMBER_ID , DECODE (prl.urgent_flag, :"SYS_B_45", :"SYS_B_46", :"SYS_B_47") URGENT , NVL(prl.urgent_flag, :"SYS_B_48") URGENT_FLAG , DECODE (prl.vmi_flag, :"SYS_B_49", :"SYS_B_50", :"SYS_B_51") VMI , NVL(prl.vmi_flag, :"SYS_B_52") VMI_FLAG , prl.wip_entity_id WIP_ENTITY_ID , prl.wip_line_id WIP_LINE_ID , NVL(prh.authorization_status, :"SYS_B_53") 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 ||:"SYS_B_54" || prl.line_num REQUEST , nvl( msi.concatenated_segments, prl.item_description) ITEM , decode(pltb.purchase_basis, :"SYS_B_55", prl.unit_price , :"SYS_B_56", decode(prl.order_type_lookup_code , :"SYS_B_57", prl.amount , :"SYS_B_58", prl.quantity * prl.unit_price) , :"SYS_B_59", prl.unit_price ) PRICE , prl.vendor_contact_id VENDOR_CONTACT_ID , prl.PARENT_REQ_LINE_ID , prl.source_type_code , ( SELECT :"SYS_B_60" FROM dual WHERE exists ( SELECT :"SYS_B_61" FROM po_req_distributions_all prd WHERE prd.requisition_line_id=prl.requisition_line_id AND prd.award_id is not null ) )AWARD_E
XISTS , 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(:"SYS_B_62") AND pltb.line_type_id = prl.line_type_id AND plttl.line_type_id = pltb.line_type_id AND plttl.language = userenv(:"SYS_B_63") 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(:"SYS_B_64") 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(:"SYS_B_65") 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 = :"SYS_B_66" AND ( NOT (pltb.order_type_lookup_code = :"SYS_B_67" AND pltb.purchase_basis = :"SYS_B_68" AND EXISTS (SELECT :"SYS_B_69" 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 = :"SYS_B_70" AND pltb.purchase_basis = :"SYS_B_71" AND EXISTS (SELECT :"SYS_B_72" 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, :"SYS_B_73") NOT IN (:"SYS_B_74", :"SYS_B_75") 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(:"SYS_B_76"), :"SYS_B_77", FND_GLOBAL.EMPLOYEE_ID, :"SYS_B_78", 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 |
| 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 ) |
| 3mhu25sfw466x | begin :1 := POR_UTIL_PKG.submitreq(:2, :3, :4, :5, :6); end; |
| 47mm81hm9sggy | SELECT sum(case when a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgw, sum(case when a.session_type = 1 and a.wait_time <> 0 then 1 else 0 end) as fgc, sum(case when a.session_type <> 1 and a.wait_time = 0 then 1 else 0 end) as bgw, sum(case when a.session_type <> 1 and a.wait_time <> 0 then 1 else 0 end) as bgc, sum(case when v.event_id is not null and a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgi FROM WRH$_ACTIVE_SESSION_HISTORY a , V$EVENT_NAME v WHERE a.event_id = v.event_id(+) AND v.wait_class(+) = 'Idle' AND a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid |
| 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' |
| 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; |
| 5vbbcp6pd58b8 | begin Fnd_Concurrent.Init_Request; end; |
| 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; |
| 6puncb1y2mfyw | SELECT SOB.SET_OF_BOOKS_ID, SOB.CHART_OF_ACCOUNTS_ID FROM GL_SETS_OF_BOOKS SOB, FINANCIALS_SYSTEM_PARAMETERS FSP WHERE FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID |
| 6vx0fw5141z4n | SELECT STATUS_FLAG FROM IGI_GCC_INSTALLED_OPTIONS WHERE OPTION_NAME = UPPER(:B1 ) |
| 733t7qc78btqw |
SELECT * FROM (SELECT DECODE(prl.po_release_id, NULL, NVL(POH.CLM_DOCUMENT_NUMBER, POH.segment1), NVL(POH.CLM_DOCUMENT_NUMBER, POH.segment1) || :"SYS_B_00" || TO_CHAR(prl.release_num)) po_number_display, NVL(POH.CLM_DOCUMENT_NUMBER, POH.segment1) po_number , poh.po_header_id po_header_id , poh.agent_id agent_id , poh.creation_date creation_date , poh.vendor_id vendor_id , poh.vendor_site_id vendor_site_id , poh.vendor_contact_id vendor_contact_id , NVL(POL.LINE_NUM_DISPLAY, to_char(POL.LINE_NUM)) line_num , pol.item_description item_description , /*5082374, we should set the unit price and uom to null for prepayments. The 0*null is used so the datatype returned from the decode is number */ DECODE(pll.shipment_type, :"SYS_B_01", DECODE(pll.matching_basis, :"SYS_B_02", :"SYS_B_03" *NULL, NVL(pll.price_override, pol.unit_price)), NVL(pll.price_override, pol.unit_price)) unit_price, DECODE(pll.shipment_type, :"SYS_B_04", DECODE(pll.matching_basis, :"SYS_B_05", NULL, pol.unit_meas_lookup_code), pol.unit_meas_lookup_code) unit_meas_lookup_code , mum.uom_class uom_class, pll.quantity quantity_ordered, pll.quantity_received quantity_received , (DECODE(pll.shipment_type, :"SYS_B_06", pll.quantity_financed, NVL(pll.quantity_billed, :"SYS_B_07"))) quantity_billed, hrl.location_code ship_to_location, pvs.vendor_site_code vendor_site_code, pvs.pay_site_flag pay_site_flag, poh.currency_code currency_code, pol.po_line_id po_line_id, pll.line_location_id line_location_id, pll.ship_to_organization_id shipto_org_id, pll.shipment_num shipment_num, pll.taxable_flag taxable_flag, pll.tax_code_id tax_code_id, hro.name organization_name, pll.org_id org_id, pll.po_release_id po_release_id, msi.concatenated_segments item_number, pol.vendor_product_num supplier_item_number, pll.amount_received amount_received, DECODE(pll.shipment_type, :"SYS_B_08", pll.amount_financed, NVL(pll.amount_billed, :"SYS_B_09")) amount_billed, pll.amount amount_ordered, NVL(pll.matching_basis, :"SYS_B_10") matching_basis, pol.item_id, flv.meaning matching_basis_meaning, prl.release_num, pv.vendor_name vendor_name, NULL waybill_airbill_num, --rsh.waybill_airbill_num, NULL packing_slip, --rsl.packing_slip, NULL container_num, --rsl.container_num, pll.match_option, pll.shipment_type, DECODE(pll.shipment_type, :"SYS_B_11", :"SYS_B_12", :"SYS_B_13") finance_flag, pll.ship_to_location_id, pv.segment1 vendor_num, (NVL(pll.quantity, :"SYS_B_14") -DECODE(pll.shipment_type, :"SYS_B_15", pll.quantity_financed, NVL(pll.quantity_billed, :"SYS_B_16")) -NVL(pll.quantity_cancelled, :"SYS_B_17")) unbilled_qty, NULL shipment_line_id, --rsl.shipment_line_id, (NVL(pll.amount, :"SYS_B_18") -DECODE(pll.shipment_type, :"SYS_B_19", pll.amount_financed, NVL(pll.amount_billed, :"SYS_B_20")) -NVL(pll.amount_cancelled, :"SYS_B_21")) unbilled_amount, poh.pay_on_code pay_on_code FROM po_headers_all poh , po_lines_all pol , po_lines_ap_v polv , po_line_locations_all pll , po_releases_all prl , po_vendor_sites_all pvs , hr_locations_all hrl , mtl_units_of_measure mum, mtl_system_items_kfv msi, hr_all_organization_units_vl hro, fnd_lookup_values_vl flv, po_vendors pv WHERE poh.po_header_id = pol.po_header_id AND poh.authorization_status = :"SYS_B_22" AND pol.po_line_id = pll.po_line_id and pol.po_line_id = polv.po_line_id AND pol.unit_meas_lookup_code = mum.unit_of_measure(+) AND pll.po_release_id = prl.po_release_id(+) AND pvs.vendor_site_id = poh.vendor_site_id AND hrl.location_id(+) = pll.ship_to_location_id AND NVL(pll.approved_flag, :"SYS_B_23") = :"SYS_B_24" AND NVL(pll.cancel_flag, :"SYS_B_25") = :"SYS_B_26" AND poh.pcard_id I
S NULL AND NVL(pll.closed_code, :"SYS_B_27") NOT IN(:"SYS_B_28", :"SYS_B_29", :"SYS_B_30") AND pll.shipment_type IN(:"SYS_B_31", :"SYS_B_32", :"SYS_B_33", :"SYS_B_34") AND hro.organization_id(+) = poh.org_id AND pol.item_id = msi.inventory_item_id(+) AND NVL(pll.consigned_flag, :"SYS_B_35") <> :"SYS_B_36" AND NVL(msi.organization_id, pll.ship_to_organization_id) = pll.ship_to_organization_id AND flv.lookup_type(+) = :"SYS_B_37" AND flv.lookup_code(+) = NVL(pll.matching_basis, :"SYS_B_38") AND pv.vendor_id = poh.vendor_id AND (DECODE(pll.shipment_type, :"SYS_B_39", DECODE(pll.matching_basis, :"SYS_B_40", (NVL(pll.quantity, :"SYS_B_41") -NVL(pll.quantity_financed, :"SYS_B_42") -NVL(pll.quantity_cancelled, :"SYS_B_43")), (NVL(pll.amount, :"SYS_B_44") -NVL(pll.amount_financed, :"SYS_B_45") -NVL(pll.amount_cancelled, :"SYS_B_46"))), :"SYS_B_47")) > :"SYS_B_48" AND NVL(pll.match_option, :"SYS_B_49") = :"SYS_B_50" UNION SELECT DECODE(prl.PO_RELEASE_ID, NULL, NVL(POH.CLM_DOCUMENT_NUMBER, POH.segment1), NVL(POH.CLM_DOCUMENT_NUMBER, POH.segment1) || :"SYS_B_51" || TO_CHAR(prl.RELEASE_NUM)) PO_NUMBER_DISPLAY, NVL(POH.CLM_DOCUMENT_NUMBER, POH.segment1) PO_NUMBER , poh.PO_HEADER_ID PO_HEADER_ID , poh.AGENT_ID AGENT_ID , poh.CREATION_DATE CREATION_DATE , poh.VENDOR_ID VENDOR_ID , poh.VENDOR_SITE_ID VENDOR_SITE_ID , poh.VENDOR_CONTACT_ID VENDOR_CONTACT_ID , NVL(POL.LINE_NUM_DISPLAY, to_char(POL.LINE_NUM)) LINE_NUM , pol.ITEM_DESCRIPTION ITEM_DESCRIPTION , /*5082374, we should set the unit price and uom to null for prepayments. The 0*null is used so the datatype returned from the decode is number */ DECODE(pll.shipment_type, :"SYS_B_52", DECODE(pll.matching_basis, :"SYS_B_53", :"SYS_B_54"*NULL, NVL(pll.PRICE_OVERRIDE, pol.UNIT_PRICE)), NVL(pll.PRICE_OVERRIDE, pol.UNIT_PRICE)) UNIT_PRICE , DECODE(pll.shipment_type, :"SYS_B_55", DECODE(pll.matching_basis, :"SYS_B_56", NULL, pol.UNIT_MEAS_LOOKUP_CODE), pol.UNIT_MEAS_LOOKUP_CODE) UNIT_MEAS_LOOKUP_CODE , mum.UOM_CLASS UOM_CLASS, PLL.QUANTITY QUANTITY_ORDERED, (AP_MATCHING_UTILS_PKG.Get_rcv_ship_qty_amt(RSL.shipment_line_id, PLL.MATCHING_BASIS, :"SYS_B_57")) QUANTITY_RECEIVED, (AP_MATCHING_UTILS_PKG.Get_rcv_ship_qty_amt(RSL.shipment_line_id, PLL.MATCHING_BASIS, :"SYS_B_58")) QUANTITY_BILLED, hrl.LOCATION_CODE SHIP_TO_LOCATION, pvs.VENDOR_SITE_CODE VENDOR_SITE_CODE, pvs.PAY_SITE_FLAG PAY_SITE_FLAG, poh.CURRENCY_CODE CURRENCY_CODE, pol.PO_LINE_ID PO_LINE_ID, pll.LINE_LOCATION_ID LINE_LOCATION_ID, pll.SHIP_TO_ORGANIZATION_ID SHIPTO_ORG_ID, pll.SHIPMENT_NUM SHIPMENT_NUM, pll.TAXABLE_FLAG TAXABLE_FLAG, pll.TAX_CODE_ID TAX_CODE_ID, hro.NAME ORGANIZATION_NAME, pll.ORG_ID ORG_ID, pll.PO_RELEASE_ID PO_RELEASE_ID, msi.CONCATENATED_SEGMENTS ITEM_NUMBER, pol.VENDOR_PRODUCT_NUM SUPPLIER_ITEM_NUMBER, (AP_MATCHING_UTILS_PKG.Get_rcv_ship_qty_amt(RSL.shipment_line_id, PLL.MATCHING_BASIS, :"SYS_B_59")) amount_received, (AP_MATCHING_UTILS_PKG.Get_rcv_ship_qty_amt( RSL.shipment_line_id, PLL.MATCHING_BASIS, :"SYS_B_60")) amount_billed, pll.amount AMOUNT_ORDERED, NVL(pll.MATCHING_BASIS, :"SYS_B_61") MATCHING_BASIS, pol.ITEM_ID, flv.meaning MATCHING_BASIS_MEANING, prl.release_num, PV.VENDOR_NAME VENDOR_NAME, RSH.WAYBILL_AIRBILL_NUM, RSL.PACKING_SLIP, RSL.CONTAINER_NUM, PLL.MATCH_OPTION, PLL.SHIPMENT_TYPE, DECODE(pll.shipment_type, :"SYS_B_62", :"SYS_B_63", :"SYS_B_64") FINANCE_FLAG, pll.ship_to_location_id, pv.segment1 vendor_num, (AP_MATCHING_UTILS_PKG.Get_rcv_ship_qty_amt( RSL.shipment_line_id, PLL.MATCHING_BASIS, :"SYS_B_65")) UN
BILLED_QTY, RSL.shipment_line_id, (AP_MATCHING_UTILS_PKG.Get_rcv_ship_qty_amt( RSL.shipment_line_id, PLL.MATCHING_BASIS, :"SYS_B_66")) UNBILLED_AMOUNT, POH.PAY_ON_CODE PAY_ON_CODE FROM PO_HEADERS_ALL poh , PO_LINES_ALL pol , po_lines_ap_v polv , PO_LINE_LOCATIONS_ALL pll , PO_RELEASES_ALL prl , PO_VENDOR_SITES_ALL pvs , HR_LOCATIONS_ALL hrl , MTL_UNITS_OF_MEASURE mum , MTL_SYSTEM_ITEMS_KFV MSI , HR_ALL_ORGANIZATION_UNITS_VL hro, fnd_lookup_values_vl flv , PO_VENDORS PV , RCV_SHIPMENT_LINES RSL , RCV_SHIPMENT_HEADERS RSH WHERE POH.PO_HEADER_ID = POL.PO_HEADER_ID AND POH.AUTHORIZATION_STATUS = :"SYS_B_67" AND POL.PO_LINE_ID = PLL.PO_LINE_ID and pol.po_line_id = polv.po_line_id AND pol.unit_meas_lookup_code = mum.unit_of_measure (+) AND PLL.PO_RELEASE_ID = PRL.PO_RELEASE_ID(+) AND pvs.vendor_site_id = poh.vendor_site_id AND hrl.location_id (+) = pll.ship_to_location_id AND NVL(pll.approved_flag, :"SYS_B_68") = :"SYS_B_69" AND NVL(pll.CANCEL_FLAG, :"SYS_B_70") = :"SYS_B_71" AND POH.pcard_id IS NULL AND NVL(pll.closed_code, :"SYS_B_72") NOT IN (:"SYS_B_73", :"SYS_B_74", :"SYS_B_75") AND pll.shipment_type IN (:"SYS_B_76", :"SYS_B_77", :"SYS_B_78", :"SYS_B_79") AND hro.ORGANIZATION_ID (+) = poh.ORG_ID AND pol.item_id = MSI.inventory_item_id (+) AND NVL(pll.consigned_flag, :"SYS_B_80") <> :"SYS_B_81" AND NVL(msi.ORGANIZATION_ID, pll.SHIP_TO_ORGANIZATION_ID) = pll.SHIP_TO_ORGANIZATION_ID AND flv.lookup_type (+) = :"SYS_B_82" AND flv.lookup_code (+) = NVL(pll.MATCHING_BASIS, :"SYS_B_83") AND PV.VENDOR_ID = POH.VENDOR_ID AND RSL.PO_LINE_LOCATION_ID(+) = PLL.LINE_LOCATION_ID AND RSH.SHIPMENT_HEADER_ID(+) = RSL.SHIPMENT_HEADER_ID AND DECODE( PLL.MATCHING_BASIS, :"SYS_B_84", AP_MATCHING_UTILS_PKG.Get_rcv_ship_qty_amt( RSL.shipment_line_id, PLL.MATCHING_BASIS, :"SYS_B_85"), AP_MATCHING_UTILS_PKG.Get_rcv_ship_qty_amt(RSL.shipment_line_id, PLL.MATCHING_BASIS, :"SYS_B_86"), :"SYS_B_87" ) > :"SYS_B_88" AND pll.match_option = :"SYS_B_89") QRSLT WHERE (UPPER(PO_NUMBER) LIKE :1 AND (PO_NUMBER LIKE :2 OR PO_NUMBER LIKE :3 OR PO_NUMBER LIKE :4 OR PO_NUMBER LIKE :5) AND NVL(PAY_ON_CODE, :"SYS_B_90") NOT IN (:"SYS_B_91") AND org_id IN (SELECT organization_id FROM per_all_assignments_f WHERE person_id=:6 AND nvl(effective_end_date, SYSDATE) >= SYSDATE)) ORDER BY PO_NUMBER desc, RELEASE_NUM desc |
| 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 |
| 91hakq9n36htp | SELECT TEXT_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1 |
| 9tmzdvyu94058 |
SELECT PoLineLocationMergeEO.OWNER_USER_ID AS "OwnerUserId", PoLineLocationMergeEO.OWNER_ROLE AS "OwnerRole", PoLineLocationMergeEO.STATUS AS "Status", PoLineLocationMergeEO.DRAFT_ID AS "DraftId", PoLineLocationMergeEO.CHANGE_ACCEPTED_FLAG AS "ChangeAcceptedFlag", PoLineLocationMergeEO.DELETE_FLAG AS "DeleteFlag", PoLineLocationMergeEO.USSGL_TRANSACTION_CODE AS "UssglTransactionCode", PoLineLocationMergeEO.GOVERNMENT_CONTEXT AS "GovernmentContext", PoLineLocationMergeEO.RECEIVING_ROUTING_ID AS "ReceivingRoutingId", PoLineLocationMergeEO.ACCRUE_ON_RECEIPT_FLAG AS "AccrueOnReceiptFlag", PoLineLocationMergeEO.CLOSED_REASON AS "ClosedReason", PoLineLocationMergeEO.CLOSED_DATE AS "ClosedDate", PoLineLocationMergeEO.CLOSED_BY AS "ClosedBy", PoLineLocationMergeEO.ORG_ID AS "OrgId", PoLineLocationMergeEO.ATTRIBUTE6 AS "Attribute6", PoLineLocationMergeEO.ATTRIBUTE7 AS "Attribute7", PoLineLocationMergeEO.ATTRIBUTE8 AS "Attribute8", PoLineLocationMergeEO.ATTRIBUTE9 AS "Attribute9", PoLineLocationMergeEO.ATTRIBUTE10 AS "Attribute10", PoLineLocationMergeEO.UNIT_OF_MEASURE_CLASS AS "UnitOfMeasureClass", PoLineLocationMergeEO.ENCUMBER_NOW AS "EncumberNow", PoLineLocationMergeEO.ATTRIBUTE11 AS "Attribute11", PoLineLocationMergeEO.ATTRIBUTE12 AS "Attribute12", PoLineLocationMergeEO.ATTRIBUTE13 AS "Attribute13", PoLineLocationMergeEO.ATTRIBUTE14 AS "Attribute14", PoLineLocationMergeEO.ATTRIBUTE15 AS "Attribute15", PoLineLocationMergeEO.INSPECTION_REQUIRED_FLAG AS "InspectionRequiredFlag", PoLineLocationMergeEO.RECEIPT_REQUIRED_FLAG AS "ReceiptRequiredFlag", PoLineLocationMergeEO.QTY_RCV_TOLERANCE AS "QtyRcvTolerance", PoLineLocationMergeEO.QTY_RCV_EXCEPTION_CODE AS "QtyRcvExceptionCode", PoLineLocationMergeEO.ENFORCE_SHIP_TO_LOCATION_CODE AS "EnforceShipToLocationCode", PoLineLocationMergeEO.ALLOW_SUBSTITUTE_RECEIPTS_FLAG AS "AllowSubstituteReceiptsFlag", PoLineLocationMergeEO.DAYS_EARLY_RECEIPT_ALLOWED AS "DaysEarlyReceiptAllowed", PoLineLocationMergeEO.DAYS_LATE_RECEIPT_ALLOWED AS "DaysLateReceiptAllowed", PoLineLocationMergeEO.RECEIPT_DAYS_EXCEPTION_CODE AS "ReceiptDaysExceptionCode", PoLineLocationMergeEO.INVOICE_CLOSE_TOLERANCE AS "InvoiceCloseTolerance", PoLineLocationMergeEO.RECEIVE_CLOSE_TOLERANCE AS "ReceiveCloseTolerance", PoLineLocationMergeEO.SHIP_TO_ORGANIZATION_ID AS "ShipToOrganizationId", PoLineLocationMergeEO.SHIPMENT_NUM AS "ShipmentNum", PoLineLocationMergeEO.SOURCE_SHIPMENT_ID AS "SourceShipmentId", PoLineLocationMergeEO.SHIPMENT_TYPE AS "ShipmentType", PoLineLocationMergeEO.CLOSED_CODE AS "ClosedCode", PoLineLocationMergeEO.REQUEST_ID AS "RequestId", PoLineLocationMergeEO.PROGRAM_APPLICATION_ID AS "ProgramApplicationId", PoLineLocationMergeEO.PROGRAM_ID AS "ProgramId", PoLineLocationMergeEO.PROGRAM_UPDATE_DATE AS "ProgramUpdateDate", PoLineLocationMergeEO.PROMISED_DATE AS "PromisedDate", PoLineLocationMergeEO.LAST_ACCEPT_DATE AS "LastAcceptDate", PoLineLocationMergeEO.PRICE_OVERRIDE AS "PriceOverride", PoLineLocationMergeEO.ENCUMBERED_FLAG AS "EncumberedFlag", PoLineLocationMergeEO.ENCUMBERED_DATE AS "EncumberedDate", PoLineLocationMergeEO.UNENCUMBERED_QUANTITY AS "UnencumberedQuantity", PoLineLocationMergeEO.FOB_LOOKUP_CODE AS "FobLookupCode", PoLineLocationMergeEO.FREIGHT_TERMS_LOOKUP_CODE AS "FreightTermsLookupCode", PoLineLocationMergeEO.TAXABLE_FLAG AS "TaxableFlag", PoLineLocationMergeEO.ESTIMATED_TAX_AMOUNT AS "Estimat
edTaxAmount", PoLineLocationMergeEO.FROM_HEADER_ID AS "FromHeaderId", PoLineLocationMergeEO.FROM_LINE_ID AS "FromLineId", PoLineLocationMergeEO.FROM_LINE_LOCATION_ID AS "FromLineLocationId", PoLineLocationMergeEO.START_DATE AS "StartDate", PoLineLocationMergeEO.END_DATE AS "EndDate", PoLineLocationMergeEO.LEAD_TIME AS "LeadTime", PoLineLocationMergeEO.LEAD_TIME_UNIT AS "LeadTimeUnit", PoLineLocationMergeEO.PRICE_DISCOUNT AS "PriceDiscount", PoLineLocationMergeEO.TERMS_ID AS "TermsId", PoLineLocationMergeEO.APPROVED_FLAG AS "ApprovedFlag", PoLineLocationMergeEO.APPROVED_DATE AS "ApprovedDate", PoLineLocationMergeEO.CLOSED_FLAG AS "ClosedFlag", PoLineLocationMergeEO.CANCEL_FLAG AS "CancelFlag", PoLineLocationMergeEO.CANCELLED_BY AS "CancelledBy", PoLineLocationMergeEO.CANCEL_DATE AS "CancelDate", PoLineLocationMergeEO.CANCEL_REASON AS "CancelReason", PoLineLocationMergeEO.FIRM_STATUS_LOOKUP_CODE AS "FirmStatusLookupCode", PoLineLocationMergeEO.FIRM_DATE AS "FirmDate", PoLineLocationMergeEO.ATTRIBUTE_CATEGORY AS "AttributeCategory", PoLineLocationMergeEO.ATTRIBUTE1 AS "Attribute1", PoLineLocationMergeEO.ATTRIBUTE2 AS "Attribute2", PoLineLocationMergeEO.ATTRIBUTE3 AS "Attribute3", PoLineLocationMergeEO.ATTRIBUTE4 AS "Attribute4", PoLineLocationMergeEO.ATTRIBUTE5 AS "Attribute5", PoLineLocationMergeEO.LINE_LOCATION_ID AS "LineLocationId", PoLineLocationMergeEO.LAST_UPDATE_DATE AS "LastUpdateDate", PoLineLocationMergeEO.LAST_UPDATED_BY AS "LastUpdatedBy", PoLineLocationMergeEO.PO_HEADER_ID AS "PoHeaderId", PoLineLocationMergeEO.PO_LINE_ID AS "PoLineId", PoLineLocationMergeEO.LAST_UPDATE_LOGIN AS "LastUpdateLogin", PoLineLocationMergeEO.CREATION_DATE AS "CreationDate", PoLineLocationMergeEO.CREATED_BY AS "CreatedBy", PoLineLocationMergeEO.QUANTITY AS "Quantity", PoLineLocationMergeEO.QUANTITY_RECEIVED AS "QuantityReceived", PoLineLocationMergeEO.QUANTITY_ACCEPTED AS "QuantityAccepted", PoLineLocationMergeEO.QUANTITY_REJECTED AS "QuantityRejected", PoLineLocationMergeEO.QUANTITY_BILLED AS "QuantityBilled", PoLineLocationMergeEO.QUANTITY_CANCELLED AS "QuantityCancelled", PoLineLocationMergeEO.UNIT_MEAS_LOOKUP_CODE AS "UnitMeasLookupCode", PoLineLocationMergeEO.PO_RELEASE_ID AS "PoReleaseId", PoLineLocationMergeEO.SHIP_TO_LOCATION_ID AS "ShipToLocationId", PoLineLocationMergeEO.SHIP_VIA_LOOKUP_CODE AS "ShipViaLookupCode", PoLineLocationMergeEO.NEED_BY_DATE AS "NeedByDate", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE_CATEGORY AS "GlobalAttributeCategory", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE1 AS "GlobalAttribute1", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE2 AS "GlobalAttribute2", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE3 AS "GlobalAttribute3", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE4 AS "GlobalAttribute4", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE5 AS "GlobalAttribute5", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE6 AS "GlobalAttribute6", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE7 AS "GlobalAttribute7", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE8 AS "GlobalAttribute8", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE9 AS "GlobalAttribute9", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE10 AS "GlobalAttribute10", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE11 AS "GlobalAttribute11", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE12 AS "GlobalAttribute12", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE13 AS "GlobalAttribute13", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE14 AS "Global
Attribute14", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE15 AS "GlobalAttribute15", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE16 AS "GlobalAttribute16", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE17 AS "GlobalAttribute17", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE18 AS "GlobalAttribute18", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE19 AS "GlobalAttribute19", PoLineLocationMergeEO.GLOBAL_ATTRIBUTE20 AS "GlobalAttribute20", PoLineLocationMergeEO.QUANTITY_SHIPPED AS "QuantityShipped", PoLineLocationMergeEO.COUNTRY_OF_ORIGIN_CODE AS "CountryOfOriginCode", PoLineLocationMergeEO.TAX_USER_OVERRIDE_FLAG AS "TaxUserOverrideFlag", PoLineLocationMergeEO.MATCH_OPTION AS "MatchOption", PoLineLocationMergeEO.TAX_CODE_ID AS "TaxCodeId", PoLineLocationMergeEO.CALCULATE_TAX_FLAG AS "CalculateTaxFlag", PoLineLocationMergeEO.CHANGE_PROMISED_DATE_REASON AS "ChangePromisedDateReason", PoLineLocationMergeEO.NOTE_TO_RECEIVER AS "NoteToReceiver", PoLineLocationMergeEO.SECONDARY_UNIT_OF_MEASURE AS "SecondaryUnitOfMeasure", PoLineLocationMergeEO.SECONDARY_QUANTITY AS "SecondaryQuantity", PoLineLocationMergeEO.PREFERRED_GRADE AS "PreferredGrade", PoLineLocationMergeEO.SECONDARY_QUANTITY_RECEIVED AS "SecondaryQuantityReceived", PoLineLocationMergeEO.SECONDARY_QUANTITY_ACCEPTED AS "SecondaryQuantityAccepted", PoLineLocationMergeEO.SECONDARY_QUANTITY_REJECTED AS "SecondaryQuantityRejected", PoLineLocationMergeEO.SECONDARY_QUANTITY_CANCELLED AS "SecondaryQuantityCancelled", PoLineLocationMergeEO.VMI_FLAG AS "VmiFlag", PoLineLocationMergeEO.CONSIGNED_FLAG AS "ConsignedFlag", PoLineLocationMergeEO.RETROACTIVE_DATE AS "RetroactiveDate", PoLineLocationMergeEO.SUPPLIER_ORDER_LINE_NUMBER AS "SupplierOrderLineNumber", PoLineLocationMergeEO.AMOUNT AS "Amount", PoLineLocationMergeEO.AMOUNT_RECEIVED AS "AmountReceived", PoLineLocationMergeEO.AMOUNT_BILLED AS "AmountBilled", PoLineLocationMergeEO.AMOUNT_CANCELLED AS "AmountCancelled", PoLineLocationMergeEO.AMOUNT_ACCEPTED AS "AmountAccepted", PoLineLocationMergeEO.AMOUNT_REJECTED AS "AmountRejected", PoLineLocationMergeEO.DROP_SHIP_FLAG AS "DropShipFlag", PoLineLocationMergeEO.SALES_ORDER_UPDATE_DATE AS "SalesOrderUpdateDate", PoLineLocationMergeEO.TRANSACTION_FLOW_HEADER_ID AS "TransactionFlowHeaderId", PoLineLocationMergeEO.FINAL_MATCH_FLAG AS "FinalMatchFlag", PoLineLocationMergeEO.MANUAL_PRICE_CHANGE_FLAG AS "ManualPriceChangeFlag", PoLineLocationMergeEO.SHIPMENT_CLOSED_DATE AS "ShipmentClosedDate", PoLineLocationMergeEO.CLOSED_FOR_RECEIVING_DATE AS "ClosedForReceivingDate", PoLineLocationMergeEO.CLOSED_FOR_INVOICE_DATE AS "ClosedForInvoiceDate", PoLineLocationMergeEO.SECONDARY_QUANTITY_SHIPPED AS "SecondaryQuantityShipped", PoLineLocationMergeEO.PAYMENT_TYPE AS "PaymentType", PoLineLocationMergeEO.DESCRIPTION AS "Description", PoLineLocationMergeEO.VALUE_BASIS AS "ValueBasis", PoLineLocationMergeEO.MATCHING_BASIS AS "MatchingBasis", PoLineLocationMergeEO.WORK_APPROVER_ID AS "WorkApproverId", PoLineLocationMergeEO.BID_PAYMENT_ID AS "BidPaymentId", PoLineLocationMergeEO.QUANTITY_FINANCED AS "QuantityFinanced", PoLineLocationMergeEO.AMOUNT_FINANCED AS "AmountFinanced", PoLineLocationMergeEO.QUANTITY_RECOUPED AS "QuantityRecouped", PoLineLocationMergeEO.AMOUNT_RECOUPED AS "AmountRecouped", PoLineLocationMergeEO.RETAINAGE_WITHHELD_AMOUNT AS "RetainageWithheldAmount", PoLineLocationMergeEO.RETAINAGE_RELEASED_AMOUNT AS "RetainageReleasedAmount", PoLineLocationMergeEO.AMOUNT_
SHIPPED AS "AmountShipped", PoLineLocationMergeEO.TAX_ATTRIBUTE_UPDATE_CODE AS "TaxAttributeUpdateCode", PoLineLocationMergeEO.OUTSOURCED_ASSEMBLY AS "OutsourcedAssembly", PoLineLocationMergeEO.TAX_NAME AS "TaxName" FROM PO_LINE_LOCATIONS_MERGE_V PoLineLocationMergeEO WHERE PoLineLocationMergeEO.LINE_LOCATION_ID = :1 |
| 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; |
| 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 |
| b5ku28kvsxwuk |
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(:"SYS_B_000") 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 ( :"SYS_B_001", :"SYS_B_002", :"SYS_B_003", :"SYS_B_004", :"SYS_B_005", :"SYS_B_006", :"SYS_B_007", :"SYS_B_008", :"SYS_B_009", :"SYS_B_010", :"SYS_B_011", :"SYS_B_012", :"SYS_B_013", :"SYS_B_014", :"SYS_B_015", :"SYS_B_016", :"SYS_B_017", :"SYS_B_018", :"SYS_B_019", :"SYS_B_020", -- <Complex Work R12> :"SYS_B_021", :"SYS_B_022", :"SYS_B_023", :"SYS_B_024", :"SYS_B_025", :"SYS_B_026", :"SYS_B_027", :"SYS_B_028", :"SYS_B_029", :"SYS_B_030", :"SYS_B_031", :"SYS_B_032", :"SYS_B_033", :"SYS_B_034", :"SYS_B_035", :"SYS_B_036", :"SYS_B_037", :"SYS_B_038", :"SYS_B_039", :"SYS_B_040", :"SYS_B_041", -- <Complex Work R12> :"SYS_B_042", -- <Complex Work R12> :"SYS_B_043", -- <Complex Work R12> :"SYS_B_044", -- <Complex Work R12> :"SYS_B_045", -- <Complex Work R12> :"SYS_B_046", :"SYS_B_047", :"SYS_B_048", :"SYS_B_049", :"SYS_B_050", :"SYS_B_051", :"SYS_B_052", :"SYS_B_053", :"SYS_B_054", :"SYS_B_055", :"SYS_B_056", :"SYS_B_057", :"SYS_B_058", :"SYS_B_059", :"SYS_B_060", :"SYS_B_061", :"SYS_B_062", :"SYS_B_063", :"SYS_B_064", :"SYS_B_065", :"SYS_B_066", :"SYS_B_067", :"SYS_B_068", :"SYS_B_069", :"SYS_B_070", :"SYS_B_071", :"SYS_B_072", :"SYS_B_073", :"SYS_B_074", :"SYS_B_075", :"SYS_B_076", :"SYS_B_077", :"SYS_B_078", :"SYS_B_079", :"SYS_B_080", :"SYS_B_081", :"SYS_B_082", :"SYS_B_083", :"SYS_B_084", :"SYS_B_085", :"SYS_B_086", :"SYS_B_087", :"SYS_B_088", :"SYS_B_089", :"SYS_B_090", :"SYS_B_091", :"SYS_B_092", :"SYS_B_093", :"SYS_B_094", :"SYS_B_095", :"SYS_B_096", :"SYS_B_097", :"SYS_B_098", :"SYS_B_099", :"SYS_B_100", :"SYS_B_101", :"SYS_B_102", :"SYS_B_103", :"SYS_B_104", :"SYS_B_105", :"SYS_B_106", :"SYS_B_107", :"SYS_B_108", :"SYS_B_109", :"SYS_B_110", :"SYS_B_111", :"SYS_B_112", :"SYS_B_113", --<Bug#: 4899200> :"SYS_B_114", --<Bug#: 4899200> :"SYS_B_115", --<Bug#: 4899200> :"SYS_B_116", --<Bug#: 5464968> :
"SYS_B_117", --Enhanced Pricing :"SYS_B_118", --Enhanced Pricing :"SYS_B_119", --Enhanced Pricing :"SYS_B_120", --Enhanced Pricing :"SYS_B_121", --Enhanced Pricing :"SYS_B_122", --Enhanced Pricing :"SYS_B_123", --Enhanced Pricing :"SYS_B_124", --Enhanced Pricing :"SYS_B_125" --<Bug#: 5464968> ) AND application_id = :"SYS_B_126" AND language_code = :"SYS_B_127") AS message, CURSOR( SELECT fds.short_text FROM fnd_attached_docs_form_vl fad, fnd_documents_short_text fds WHERE ((entity_name = :"SYS_B_128" AND pk1_value = to_char(phx.po_header_id)) OR (entity_name = :"SYS_B_129" AND pk1_value = to_char(phx.vendor_id)) OR (entity_name = :"SYS_B_130" AND pk1_value = to_char(phx.vendor_site_id))) AND -- bug6154354 function_name = :"SYS_B_131" AND fad.media_id = fds.media_id AND fad.datatype_id=:"SYS_B_132" 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=:"SYS_B_133" AND fad.pk1_value=to_char(phx.po_header_id)) OR (fad.entity_name=:"SYS_B_134" AND fad.pk1_value=to_char(phx.vendor_id)) OR (fad.entity_name=:"SYS_B_135" AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354 ) AND fad.datatype_id=:"SYS_B_136" AND fad.function_name=:"SYS_B_137" 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=:"SYS_B_138" AND fad.pk1_value=to_char(phx.po_header_id)) OR (fad.entity_name=:"SYS_B_139" AND fad.pk1_value=to_char(phx.vendor_id)) OR (fad.entity_name=:"SYS_B_140" AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354 ) AND fad.datatype_id=:"SYS_B_141" AND fad.function_name=:"SYS_B_142" 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=:"SYS_B_143" AND entity_id = plx.po_line_id and enabled_flag=:"SYS_B_144") 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=:"SYS_B_145" AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name=:"SYS_B_146" 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=:"SYS_B_147" AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_148" AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_149" AND fad.pk1_value=to_char(plx.CONTRACT_ID) AND plx.CONTRACT_ID IS NOT NULL) ) AND function_name = :"SYS_B_150" AND fad.media_id = fds.media_id AND fad.datatype_id=:"SYS_B_151" 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=:"SYS_B_152" AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name=:"S
YS_B_153" AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_154" AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_155" AND fad.pk1_value=to_char(plx.contract_id) AND plx.contract_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_156" 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=:"SYS_B_157" AND fad.function_name=:"SYS_B_158" 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=:"SYS_B_159" AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name=:"SYS_B_160" AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_161" AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_162" AND fad.pk1_value=to_char(plx.contract_id) AND plx.contract_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_163" 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=:"SYS_B_164" AND fad.function_name=:"SYS_B_165" 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 = :"SYS_B_166" AND pk1_value = to_char(pllx.line_location_id) AND function_name = :"SYS_B_167" AND fad.media_id = fds.media_id AND fad.datatype_id=:"SYS_B_168" 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=:"SYS_B_169" AND fad.pk1_value=to_char(pllx.line_location_id) AND fad.datatype_id=:"SYS_B_170" AND fad.function_name=:"SYS_B_171" 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=:"SYS_B_172" AND fad.pk1_value=to_char(pllx.line_location_id) AND fad.datatype_id=:"SYS_B_173" AND fad.function_name=:"SYS_B_174" 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, :"SYS_B_175") NOT IN (:"SYS_B_176", :"SYS_B_177") ) 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() |
| bbugagurwv1vy | (SELECT STATUS_FLAG FROM IGI_GCC_INSTALLED_OPTIONS WHERE OPTION_NAME = UPPER(:B1 )) |
| bf7uwg5pa3pj6 | begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end; |
| 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; |
| cd02js3xuc27n |
SELECT PoLineMergeEO.DRAFT_ID AS "DraftId", PoLineMergeEO.CHANGE_ACCEPTED_FLAG AS "ChangeAcceptedFlag", PoLineMergeEO.DELETE_FLAG AS "DeleteFlag", PoLineMergeEO.ATTRIBUTE9 AS "Attribute9", PoLineMergeEO.ATTRIBUTE10 AS "Attribute10", PoLineMergeEO.REFERENCE_NUM AS "ReferenceNum", PoLineMergeEO.ATTRIBUTE11 AS "Attribute11", PoLineMergeEO.ATTRIBUTE12 AS "Attribute12", PoLineMergeEO.ATTRIBUTE13 AS "Attribute13", PoLineMergeEO.ATTRIBUTE14 AS "Attribute14", PoLineMergeEO.ATTRIBUTE15 AS "Attribute15", PoLineMergeEO.MIN_RELEASE_AMOUNT AS "MinReleaseAmount", PoLineMergeEO.PRICE_TYPE_LOOKUP_CODE AS "PriceTypeLookupCode", PoLineMergeEO.CLOSED_CODE AS "ClosedCode", PoLineMergeEO.PRICE_BREAK_LOOKUP_CODE AS "PriceBreakLookupCode", PoLineMergeEO.USSGL_TRANSACTION_CODE AS "UssglTransactionCode", PoLineMergeEO.GOVERNMENT_CONTEXT AS "GovernmentContext", PoLineMergeEO.REQUEST_ID AS "RequestId", PoLineMergeEO.PROGRAM_APPLICATION_ID AS "ProgramApplicationId", PoLineMergeEO.PROGRAM_ID AS "ProgramId", PoLineMergeEO.PROGRAM_UPDATE_DATE AS "ProgramUpdateDate", PoLineMergeEO.CLOSED_DATE AS "ClosedDate", PoLineMergeEO.CLOSED_REASON AS "ClosedReason", PoLineMergeEO.CLOSED_BY AS "ClosedBy", PoLineMergeEO.TRANSACTION_REASON_CODE AS "TransactionReasonCode", PoLineMergeEO.ORG_ID AS "OrgId", PoLineMergeEO.HAZARD_CLASS_ID AS "HazardClassId", PoLineMergeEO.NOTE_TO_VENDOR AS "NoteToVendor", PoLineMergeEO.FROM_HEADER_ID AS "FromHeaderId", PoLineMergeEO.FROM_LINE_ID AS "FromLineId", PoLineMergeEO.MIN_ORDER_QUANTITY AS "MinOrderQuantity", PoLineMergeEO.MAX_ORDER_QUANTITY AS "MaxOrderQuantity", PoLineMergeEO.QTY_RCV_TOLERANCE AS "QtyRcvTolerance", PoLineMergeEO.OVER_TOLERANCE_ERROR_FLAG AS "OverToleranceErrorFlag", PoLineMergeEO.MARKET_PRICE AS "MarketPrice", PoLineMergeEO.UNORDERED_FLAG AS "UnorderedFlag", PoLineMergeEO.CLOSED_FLAG AS "ClosedFlag", PoLineMergeEO.USER_HOLD_FLAG AS "UserHoldFlag", PoLineMergeEO.CANCEL_FLAG AS "CancelFlag", PoLineMergeEO.CANCELLED_BY AS "CancelledBy", PoLineMergeEO.CANCEL_DATE AS "CancelDate", PoLineMergeEO.CANCEL_REASON AS "CancelReason", PoLineMergeEO.FIRM_STATUS_LOOKUP_CODE AS "FirmStatusLookupCode", PoLineMergeEO.FIRM_DATE AS "FirmDate", PoLineMergeEO.VENDOR_PRODUCT_NUM AS "VendorProductNum", PoLineMergeEO.CONTRACT_NUM AS "ContractNum", PoLineMergeEO.TAXABLE_FLAG AS "TaxableFlag", PoLineMergeEO.TYPE_1099 AS "Type1099", PoLineMergeEO.CAPITAL_EXPENSE_FLAG AS "CapitalExpenseFlag", PoLineMergeEO.NEGOTIATED_BY_PREPARER_FLAG AS "NegotiatedByPreparerFlag", PoLineMergeEO.ATTRIBUTE_CATEGORY AS "AttributeCategory", PoLineMergeEO.ATTRIBUTE1 AS "Attribute1", PoLineMergeEO.ATTRIBUTE2 AS "Attribute2", PoLineMergeEO.ATTRIBUTE3 AS "Attribute3", PoLineMergeEO.ATTRIBUTE4 AS "Attribute4", PoLineMergeEO.ATTRIBUTE5 AS "Attribute5", PoLineMergeEO.ATTRIBUTE6 AS "Attribute6", PoLineMergeEO.ATTRIBUTE7 AS "Attribute7", PoLineMergeEO.ATTRIBUTE8 AS "Attribute8", PoLineMergeEO.QC_GRADE AS "QcGrade", PoLineMergeEO.BASE_UOM AS "BaseUom", PoLineMergeEO.BASE_QTY AS "BaseQty", PoLineMergeEO.SECONDARY_UOM AS "SecondaryUom", PoLineMergeEO.SECONDARY_QTY AS "SecondaryQty", PoLineMergeEO.PO_LINE_ID AS "PoLineId", PoLineMergeEO.LAST_UPDATE_DATE AS "LastUpdateDate", PoLineMergeEO.LAST_UPDATED_BY AS "LastUpdatedBy", PoLineMergeEO.PO_HEADER_ID AS
"PoHeaderId", PoLineMergeEO.LINE_TYPE_ID AS "LineTypeId", PoLineMergeEO.LINE_NUM AS "LineNum", PoLineMergeEO.LAST_UPDATE_LOGIN AS "LastUpdateLogin", PoLineMergeEO.CREATION_DATE AS "CreationDate", PoLineMergeEO.CREATED_BY AS "CreatedBy", PoLineMergeEO.ITEM_ID AS "ItemId", PoLineMergeEO.ITEM_REVISION AS "ItemRevision", PoLineMergeEO.CATEGORY_ID AS "CategoryId", PoLineMergeEO.ITEM_DESCRIPTION AS "ItemDescription", PoLineMergeEO.UNIT_MEAS_LOOKUP_CODE AS "UnitMeasLookupCode", PoLineMergeEO.QUANTITY_COMMITTED AS "QuantityCommitted", PoLineMergeEO.COMMITTED_AMOUNT AS "CommittedAmount", PoLineMergeEO.ALLOW_PRICE_OVERRIDE_FLAG AS "AllowPriceOverrideFlag", PoLineMergeEO.NOT_TO_EXCEED_PRICE AS "NotToExceedPrice", PoLineMergeEO.LIST_PRICE_PER_UNIT AS "ListPricePerUnit", PoLineMergeEO.UNIT_PRICE AS "UnitPrice", PoLineMergeEO.QUANTITY AS "Quantity", PoLineMergeEO.UN_NUMBER_ID AS "UnNumberId", PoLineMergeEO.GLOBAL_ATTRIBUTE_CATEGORY AS "GlobalAttributeCategory", PoLineMergeEO.GLOBAL_ATTRIBUTE1 AS "GlobalAttribute1", PoLineMergeEO.GLOBAL_ATTRIBUTE2 AS "GlobalAttribute2", PoLineMergeEO.GLOBAL_ATTRIBUTE3 AS "GlobalAttribute3", PoLineMergeEO.GLOBAL_ATTRIBUTE4 AS "GlobalAttribute4", PoLineMergeEO.GLOBAL_ATTRIBUTE5 AS "GlobalAttribute5", PoLineMergeEO.GLOBAL_ATTRIBUTE6 AS "GlobalAttribute6", PoLineMergeEO.GLOBAL_ATTRIBUTE7 AS "GlobalAttribute7", PoLineMergeEO.GLOBAL_ATTRIBUTE8 AS "GlobalAttribute8", PoLineMergeEO.GLOBAL_ATTRIBUTE9 AS "GlobalAttribute9", PoLineMergeEO.GLOBAL_ATTRIBUTE10 AS "GlobalAttribute10", PoLineMergeEO.GLOBAL_ATTRIBUTE11 AS "GlobalAttribute11", PoLineMergeEO.GLOBAL_ATTRIBUTE12 AS "GlobalAttribute12", PoLineMergeEO.GLOBAL_ATTRIBUTE13 AS "GlobalAttribute13", PoLineMergeEO.GLOBAL_ATTRIBUTE14 AS "GlobalAttribute14", PoLineMergeEO.GLOBAL_ATTRIBUTE15 AS "GlobalAttribute15", PoLineMergeEO.GLOBAL_ATTRIBUTE16 AS "GlobalAttribute16", PoLineMergeEO.GLOBAL_ATTRIBUTE17 AS "GlobalAttribute17", PoLineMergeEO.GLOBAL_ATTRIBUTE18 AS "GlobalAttribute18", PoLineMergeEO.GLOBAL_ATTRIBUTE19 AS "GlobalAttribute19", PoLineMergeEO.GLOBAL_ATTRIBUTE20 AS "GlobalAttribute20", PoLineMergeEO.LINE_REFERENCE_NUM AS "LineReferenceNum", PoLineMergeEO.PROJECT_ID AS "ProjectId", PoLineMergeEO.TASK_ID AS "TaskId", PoLineMergeEO.EXPIRATION_DATE AS "ExpirationDate", PoLineMergeEO.TAX_CODE_ID AS "TaxCodeId", PoLineMergeEO.OKE_CONTRACT_HEADER_ID AS "OkeContractHeaderId", PoLineMergeEO.OKE_CONTRACT_VERSION_ID AS "OkeContractVersionId", PoLineMergeEO.TAX_NAME AS "TaxName", PoLineMergeEO.SECONDARY_UNIT_OF_MEASURE AS "SecondaryUnitOfMeasure", PoLineMergeEO.SECONDARY_QUANTITY AS "SecondaryQuantity", PoLineMergeEO.PREFERRED_GRADE AS "PreferredGrade", PoLineMergeEO.AUCTION_HEADER_ID AS "AuctionHeaderId", PoLineMergeEO.AUCTION_DISPLAY_NUMBER AS "AuctionDisplayNumber", PoLineMergeEO.AUCTION_LINE_NUMBER AS "AuctionLineNumber", PoLineMergeEO.BID_NUMBER AS "BidNumber", PoLineMergeEO.BID_LINE_NUMBER AS "BidLineNumber", PoLineMergeEO.RETROACTIVE_DATE AS "RetroactiveDate", PoLineMergeEO.SUPPLIER_REF_NUMBER AS "SupplierRefNumber", PoLineMergeEO.CONTRACT_ID AS "ContractId", PoLineMergeEO.JOB_ID AS "JobId", PoLineMergeEO.AMOUNT AS "Amount", PoLineMergeEO.START_DATE AS "StartDate", PoLineMergeEO.CONTRACTOR_FIRST_NAME AS "ContractorFirstName", PoLineMergeEO.CONTRACTOR_LAST_NAME AS "ContractorLastName
", PoLineMergeEO.ORDER_TYPE_LOOKUP_CODE AS "OrderTypeLookupCode", PoLineMergeEO.PURCHASE_BASIS AS "PurchaseBasis", PoLineMergeEO.MATCHING_BASIS AS "MatchingBasis", PoLineMergeEO.SVC_AMOUNT_NOTIF_SENT AS "SvcAmountNotifSent", PoLineMergeEO.SVC_COMPLETION_NOTIF_SENT AS "SvcCompletionNotifSent", PoLineMergeEO.FROM_LINE_LOCATION_ID AS "FromLineLocationId", PoLineMergeEO.BASE_UNIT_PRICE AS "BaseUnitPrice", PoLineMergeEO.MANUAL_PRICE_CHANGE_FLAG AS "ManualPriceChangeFlag", PoLineMergeEO.RETAINAGE_RATE AS "RetainageRate", PoLineMergeEO.MAX_RETAINAGE_AMOUNT AS "MaxRetainageAmount", PoLineMergeEO.PROGRESS_PAYMENT_RATE AS "ProgressPaymentRate", PoLineMergeEO.RECOUPMENT_RATE AS "RecoupmentRate", PoLineMergeEO.SUPPLIER_PART_AUXID AS "SupplierPartAuxid", PoLineMergeEO.IP_CATEGORY_ID AS "IpCategoryId", PoLineMergeEO.TAX_ATTRIBUTE_UPDATE_CODE AS "TaxAttributeUpdateCode", PoLineMergeEO.CATALOG_NAME AS "CatalogName" FROM PO_LINES_MERGE_V PoLineMergeEO WHERE PoLineMergeEO.PO_LINE_ID = :1 |
| 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; |
| d3pkzg7h1v8uq |
SELECT * FROM (SELECT POH.ACCEPTANCE_DUE_DATE ACKNOWLEDGE_BY, NVL(POH.ACCEPTANCE_REQUIRED_FLAG, :"SYS_B_00") ACCEPTANCE_REQUIRED_FLAG, DECODE(POH.APPROVED_FLAG, :"SYS_B_01", POH.APPROVED_DATE, NULL) APPROVED_DATE, POH.BILL_TO_LOCATION_ID, POH.AGENT_ID, NVL(POH.CANCEL_FLAG, :"SYS_B_02") HEADER_CANCEL_FLAG, POH.CLOSED_DATE, NVL(POH.CLOSED_CODE, :"SYS_B_03") HEADER_CLOSED_CODE, POH.CONFIRMING_ORDER_FLAG, POH.CONSIGNED_CONSUMPTION_FLAG, NVL(POH.CONTERMS_EXIST_FLAG, :"SYS_B_04") CONTERMS_EXIST_FLAG, POH.CURRENCY_CODE CURRENCY_CODE, POH.COMMENTS DESCRIPTION, NVL(POH.FIRM_STATUS_LOOKUP_CODE, :"SYS_B_05") FIRM_STATUS_LOOKUP_CODE, POH.FIRM_DATE, POH.FOB_LOOKUP_CODE, POH.FREIGHT_TERMS_LOOKUP_CODE, NVL(POH.FROZEN_FLAG, :"SYS_B_06") FROZEN_FLAG, POH.NOTE_TO_RECEIVER, POH.NOTE_TO_VENDOR, POH.SEGMENT1 PO_NUM, NVL(POH.USER_HOLD_FLAG, :"SYS_B_07") USER_HOLD_FLAG, POH.ORG_ID, POH.CREATION_DATE HEADER_CREATION_DATE, POH.PCARD_ID, POH.PAY_ON_CODE, POH.PRINT_COUNT, POH.PRINTED_DATE, POH.RATE RATE, POH.RATE_DATE, POH.RATE_TYPE RATE_TYPE, POH.REVISED_DATE, POH.REVISION_NUM, POH.SHIP_VIA_LOOKUP_CODE, POH.VENDOR_ID, POH.VENDOR_CONTACT_ID, POH.VENDOR_SITE_ID, POH.TERMS_ID, POH.SHIPPING_CONTROL, POH.TYPE_LOOKUP_CODE, DECODE(POH.XML_CHANGE_SEND_DATE, NULL, POH.XML_SEND_DATE, POH.XML_CHANGE_SEND_DATE) XML_SEND_DATE, POH.BLANKET_TOTAL_AMOUNT, POH.START_DATE EFFECTIVE_FROM, POH.END_DATE EFFECTIVE_TO, POH.GLOBAL_AGREEMENT_FLAG, POH.AMOUNT_LIMIT, POH.PRICE_UPDATE_TOLERANCE, POH.STYLE_ID, NVL(POH.ENCUMBRANCE_REQUIRED_FLAG, :"SYS_B_08") ENCUMBRANCE_REQUIRED_FLAG, POH.CHANGE_REQUESTED_BY, POH.ATTRIBUTE1, POH.ATTRIBUTE2, POH.ATTRIBUTE3, POH.ATTRIBUTE4, POH.ATTRIBUTE5, POH.ATTRIBUTE6, POH.ATTRIBUTE7, POH.ATTRIBUTE8, POH.ATTRIBUTE9, POH.ATTRIBUTE10, POH.ATTRIBUTE11, POH.ATTRIBUTE12, POH.ATTRIBUTE13, POH.ATTRIBUTE14, POH.ATTRIBUTE15, POH.PO_HEADER_ID, NVL(POH.AUTHORIZATION_STATUS, :"SYS_B_09") AUTHORIZATION_STATUS, NVL(POH.SUPPLIER_AUTH_ENABLED_FLAG, :"SYS_B_10") SUPPLIER_AUTH_ENABLED_FLAG, PDTL.TYPE_NAME DOC_TYPE_NAME, PDTL.DOCUMENT_TYPE_CODE DOCUMENT_TYPE_CODE, AT.NAME TERMS_NAME, HRL2.LOCATION_CODE BILL_TO_LOCATION, V.VENDOR_NAME SUPPLIER, VS.VENDOR_SITE_CODE SUPPLIER_SITE, POD.AMOUNT_TO_ENCUMBER, POD.BUDGET_ACCOUNT_ID, POD.ENCUMBERED_FLAG, POD.ENCUMBERED_AMOUNT, POD.GL_ENCUMBERED_DATE, POD.GL_ENCUMBERED_PERIOD_NAME ENCUMBERED_PERIOD, POD.UNENCUMBERED_AMOUNT BLANKET_UNENCUMBERED_AMOUNT, POAH.ACTION_DATE CANCELED_DATE, POAH.EMPLOYEE_ID CANCELED_BY_ID, NVL(PO_MOAC_UTILS_PVT.GET_OU_SHORTCODE(POH.ORG_ID), PO_MOAC_UTILS_PVT.GET_OU_NAME(POH.ORG_ID)) OPERATING_UNIT, POH.ATTRIBUTE_CATEGORY, PDSLVL.DISPLAY_NAME DOC_STYLE, PDT.SECURITY_LEVEL_CODE, PDT.ACCESS_LEVEL_CODE, NVL(POH.PENDING_SIGNATURE_FLAG, :"SYS_B_11") PENDING_SIGNATURE_FLAG, POH.LOCK_OWNER_ROLE, POD.PO_DISTRIBUTION_ID, POH.SUPPLIER_NOTIF_METHOD, POH.FAX, POH.EMAIL_ADDRESS, -- Bug 5468465 NVL(POH.CAT_ADMIN_AUTH_ENABLED_FLAG, :"SYS_B_12") CAT_ADMIN_AUTH_ENABLED_FLAG FROM PO_DOCUMENT_TYPES_ALL_B PDT, PO_DOCUMENT_TYPES_ALL_TL PDTL, PO_VENDORS V, PO_VENDOR_SITES_ALL VS, PO_VENDOR_CONTACTS VC, AP_TERMS AT, HR_LOCATIONS_ALL_TL HRL2, PO_HEADERS_ALL POH, PO_DISTRIBUTIONS_ALL POD, PO_ACTION_HISTORY POAH, PO_DOC_STYLE_LINES_VL PDSLVL WHERE PDT.DOCUMENT_TYPE_CODE = :1 AND PDT.DOCUMENT_SUBTYPE = POH.TYPE_LOOKUP_CODE AND PDT.DOCUMENT_TYPE_CODE = PDTL.DOCUMENT_TYPE_CODE AND PDT.DOCUMENT_SUBTYPE = PDTL.DOCUMENT_SUBTYPE AND PDTL.LANGUAGE = USERENV(:"SYS_B_13") AND PDT.ORG_ID = PDTL.ORG_ID AND PDT.ORG_ID = POH.ORG_ID AND V.VENDOR_ID (+) = POH.VENDOR_ID AND VS.VENDOR_SITE_ID (+) = POH.VENDOR_SITE_ID AND VC.VENDOR_CONTACT_ID (+) = POH.VENDOR_CONTACT_ID AND /* Bug 6241452 */ ( POH.VENDOR_CONTACT_ID IS NULL OR POH.VENDOR_SITE_ID=VC.VENDOR_SITE_ID ) AND AT.TERM_ID (+) = POH
.TERMS_ID AND POH.PO_HEADER_ID = POD.PO_HEADER_ID (+) AND :"SYS_B_14" = POD.DISTRIBUTION_TYPE (+) AND POH.REVISION_NUM = POAH.OBJECT_REVISION_NUM (+) AND POH.PO_HEADER_ID = POAH.OBJECT_ID (+) AND POH.TYPE_LOOKUP_CODE = POAH.OBJECT_SUB_TYPE_CODE (+) AND :2 = POAH.OBJECT_TYPE_CODE (+) AND POAH.ACTION_CODE (+) = :"SYS_B_15" AND HRL2.LOCATION_ID (+) = POH.BILL_TO_LOCATION_ID AND HRL2.LANGUAGE (+) = USERENV(:"SYS_B_16") AND ( ( NVL(POH.GLOBAL_AGREEMENT_FLAG, :"SYS_B_17") = :"SYS_B_18" AND (PO_MOAC_UTILS_PVT.check_access(POH.ORG_ID) = :"SYS_B_19" OR EXISTS ( SELECT :"SYS_B_20" FROM PO_GA_ORG_ASSIGNMENTS POGA WHERE POH.PO_HEADER_ID = POGA.PO_HEADER_ID AND POGA.ENABLED_FLAG =:"SYS_B_21" AND (PO_MOAC_UTILS_PVT.check_access(POGA.ORGANIZATION_ID) = :"SYS_B_22" OR PO_MOAC_UTILS_PVT.check_access(POGA.PURCHASING_ORG_ID) = :"SYS_B_23" ) ) AND POH.AUTHORIZATION_STATUS = :"SYS_B_24" AND NVL(POH.CLOSED_CODE, :"SYS_B_25") <> :"SYS_B_26" AND NVL(POH.CANCEL_FLAG, :"SYS_B_27") = :"SYS_B_28" AND NVL(POH.FROZEN_FLAG, :"SYS_B_29") = :"SYS_B_30" AND ( TRUNC(SYSDATE) BETWEEN NVL(TRUNC(POH.START_DATE), TRUNC(SYSDATE) -:"SYS_B_31") AND NVL(TRUNC(POH.END_DATE), TRUNC(SYSDATE)+:"SYS_B_32") OR ( TRUNC(POH.START_DATE) IS NOT NULL AND TRUNC(SYSDATE) <= TRUNC(POH.START_DATE)) ) ) ) OR (NVL(GLOBAL_AGREEMENT_FLAG, :"SYS_B_33") = :"SYS_B_34" AND TYPE_LOOKUP_CODE = :"SYS_B_35" AND PO_MOAC_UTILS_PVT.CHECK_ACCESS (POH.ORG_ID ) = :"SYS_B_36") ) AND POH.STYLE_ID = PDSLVL.STYLE_ID (+) AND POH.TYPE_LOOKUP_CODE = PDSLVL.DOCUMENT_SUBTYPE (+) AND PDSLVL.ENABLED_FLAG (+) = :"SYS_B_37" AND (:3<> :"SYS_B_38" OR POH.CAT_ADMIN_AUTH_ENABLED_FLAG = :"SYS_B_39") AND (/** always allow access to the buyer of the document **/ (agent_id = :4) OR ( ( (access_level_code IS NULL OR access_level_code = :"SYS_B_40") OR /** If the access level is View Only, prevent Modify or Full access **/ (access_level_code = :"SYS_B_41" AND :5 NOT IN (:"SYS_B_42", :"SYS_B_43")) OR /** If the access level is Modify, prevent Full access **/ (access_level_code = :"SYS_B_44" AND :6 <> :"SYS_B_45")) AND ( (security_level_code = :"SYS_B_46") OR (security_level_code IN (:"SYS_B_47", :"SYS_B_48", :"SYS_B_49") AND EXISTS ( SELECT :"SYS_B_50" FROM PO_ACTION_HISTORY POAH WHERE POAH.employee_id = :7 AND POAH.object_type_code IN (:"SYS_B_51", :"SYS_B_52") AND POAH.object_id = POH.po_header_id) ) OR (security_level_code = :"SYS_B_53" AND EXISTS ( SELECT :"SYS_B_54" FROM po_agents poa WHERE poa.agent_id = :8 AND SYSDATE BETWEEN NVL(POA.start_date_active, SYSDATE) AND NVL(POA.end_date_active, SYSDATE + :"SYS_B_55")) ) OR (security_level_code = :"SYS_B_56" AND EXISTS ( SELECT :"SYS_B_57" /** use aliases to avoid clashes with the main query for the org_id column name **/ FROM (SELECT org_id poeh_org_id, position_structure_id, employee_id, superior_id FROM po_employee_hierarchies) poeh, (SELECT org_id psp_org_id, security_position_structure_id FROM po_system_parameters_all) psp WHERE poeh.superior_id = :9 AND psp.psp_org_id = POH.org_id AND poeh.employee_id = agent_id AND poeh.position_structure_id = NVL(psp.security_position_structure_id, -:"SYS_B_58") ) ) ) ) ) AND :"SYS_B_59" = Decode(Nvl(FND_PROFILE.Value(:"SYS_B_60"), :"SYS_B_61"), :"SYS_B_62", PA_PO_INTEGRATION_UTILS.PA_USER_PO_ACCESS_CHECK(poh.po_header_id, :10, :"SYS_B_63"), :"SYS_B_64")) QRSLT WHERE (AGENT_ID = :11 AND ( UPPER(AUTHORIZATION_STATUS) = UPPER(:12) AND (AUTHORIZATION_STATUS like :13 OR AUTHORIZATION_STATUS like :14
OR AUTHORIZATION_STATUS like :15 OR AUTHORIZATION_STATUS like :16))) ORDER BY header_creation_date DESC |
| dawf7hvg1ym94 | select V.PROFILE_OPTION_VALUE from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V where O.PROFILE_OPTION_NAME = :1 and V.LEVEL_ID = :2 and O.START_DATE_ACTIVE <= SYSDATE and nvl(O.END_DATE_ACTIVE, SYSDATE) >= SYSDATE and O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID and O.APPLICATION_ID = V.APPLICATION_ID and V.LEVEL_VALUE = :3 |
| 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) |
| dtv3rtt90j9dy | Select R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = :"SYS_B_00" And R.Status_Code = :"SYS_B_01" And R.Requested_Start_Date <= Sysdate And (R.Node_Name1 is null or (R.Node_Name1 is not null and FND_DCP.target_node_mgr_chk(R.request_id) = :"SYS_B_02")) AND EXISTS ( Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = :"SYS_B_03" And R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id = C.CD_Id ) ) And (P.Execution_Method_Code != :"SYS_B_04" OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((:"SYS_B_05", :"SYS_B_06"), (:"SYS_B_07", :"SYS_B_08"), (:"SYS_B_09", :"SYS_B_10"), (:"SYS_B_11", :"SYS_B_12"), (:"SYS_B_13", :"SYS_B_14"))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) NOT IN ((:"SYS_B_15", :"SYS_B_16"), (:"SYS_B_17", :"SYS_B_18"), (:"SYS_B_19", :"SYS_B_20"), (:"SYS_B_21", :"SYS_B_22"), (:"SYS_B_23", :"SYS_B_24"), (:"SYS_B_25", :"SYS_B_26"), (:"SYS_B_27", :"SYS_B_28"), (:"SYS_B_29", :"SYS_B_30"), (:"SYS_B_31", :"SYS_B_32")))) ORDER BY NVL(R.priority, :"SYS_B_33"), R.Priority_Request_ID, R.Request_ID |
| du9txjm3qa2yw | begin PO_REQAPPROVAL_ACTION.DOC_COMPLETE_CHECK (:v1, :v2, :v3, :v4, :v5); end; |
| f2mg2y50g364u | SELECT DEFAULT_TAXATION_COUNTRY , DOCUMENT_SUB_TYPE, TAX_INVOICE_DATE FROM ZX_LINES_DET_FACTORS WHERE APPLICATION_ID = :B4 AND ENTITY_CODE = :B3 AND EVENT_CLASS_CODE = :B2 AND TRX_ID = :B1 AND ROWNUM = 1 |
| 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 |