ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 3A3607E3F708AEECE06362FB09056A61Y with document_types_ as ( select /*+ inline */ case when pdtav.document_type_code='QUOTATION' then pdtav.document_type_code else pdtav.document_subtype end document_type, pdtav.type_name document_type_name from po_document_types_all_vl pdtav, hr_all_organization_units_vl haouv where 2=2 and 3=3 and pdtav.org_id=haouv.organization_id and pdtav.document_type_code in ('PO','PA','QUOTATION') and pdtav.document_subtype in ('BLANKET','CONTRACT','STANDARD') ), po_lines_ as ( select /*+ inline */ pla.po_line_id, pla.note_to_vendor, pla.line_reference_num, pla.po_header_id, pla.line_num, pltt.line_type, msiv.concatenated_segments item, pla.item_revision, pla.unit_meas_lookup_code unit_of_measure, pla.unit_price, xxen_util.meaning(pla.allow_price_override_flag,'YES_NO',0) allow_price_override, pla.not_to_exceed_price limit_price, pla.quantity line_quantity, pla.item_description description, pla.vendor_product_num supplier_item, mcv.category_concat_segs category, xxen_util.display_flexfield_context(201,'PO_LINES',pla.attribute_category) line_dff_context, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE1',pla.rowid,pla.attribute1) line_attribute1, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE2',pla.rowid,pla.attribute2) line_attribute2, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE3',pla.rowid,pla.attribute3) line_attribute3, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE4',pla.rowid,pla.attribute4) line_attribute4, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE5',pla.rowid,pla.attribute5) line_attribute5, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE6',pla.rowid,pla.attribute6) line_attribute6, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE7',pla.rowid,pla.attribute7) line_attribute7, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE8',pla.rowid,pla.attribute8) line_attribute8, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE9',pla.rowid,pla.attribute9) line_attribute9, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE10',pla.rowid,pla.attribute10) line_attribute10, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE11',pla.rowid,pla.attribute11) line_attribute11, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE12',pla.rowid,pla.attribute12) line_attribute12, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE13',pla.rowid,pla.attribute13) line_attribute13, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE14',pla.rowid,pla.attribute14) line_attribute14, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE15',pla.rowid,pla.attribute15) line_attribute15 from po_lines_all pla, po_line_types_tl pltt, mtl_categories_v mcv, mtl_system_items_vl msiv where nvl(pla.cancel_flag,'N')='N' and nvl(pla.closed_code,'OPEN')<>'FINALLY CLOSED' and pltt.language=userenv('lang') and pltt.line_type_id=pla.line_type_id and pla.category_id=mcv.category_id(+) and msiv.inventory_item_id(+) = pla.item_id and msiv.organization_id(+) = xxen_po_upload.get_inv_org_id(pla.org_id) ), po_line_locations_ as ( select /*+ inline */ plla.po_line_id, plla.line_location_id, plla.shipment_num, plla.quantity ship_quantity, plla.price_override break_price, plla.unit_meas_lookup_code break_unit_of_measure, plla.price_discount discount, mp.organization_code ship_to_organization_code, hla.location_code ship_to_location_code, plla.need_by_date, plla.promised_date, plla.start_date price_break_start_date, plla.end_date price_break_end_date, xxen_util.display_flexfield_context(201,'PO_LINE_LOCATIONS',plla.attribute_category) line_location_dff_context, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE1',plla.rowid,plla.attribute1) line_location_attribute1, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE2',plla.rowid,plla.attribute2) line_location_attribute2, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE3',plla.rowid,plla.attribute3) line_location_attribute3, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE4',plla.rowid,plla.attribute4) line_location_attribute4, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE5',plla.rowid,plla.attribute5) line_location_attribute5, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE6',plla.rowid,plla.attribute6) line_location_attribute6, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE7',plla.rowid,plla.attribute7) line_location_attribute7, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE8',plla.rowid,plla.attribute8) line_location_attribute8, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE9',plla.rowid,plla.attribute9) line_location_attribute9, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE10',plla.rowid,plla.attribute10) line_location_attribute10, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE11',plla.rowid,plla.attribute11) line_location_attribute11, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE12',plla.rowid,plla.attribute12) line_location_attribute12, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE13',plla.rowid,plla.attribute13) line_location_attribute13, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE14',plla.rowid,plla.attribute14) line_location_attribute14, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE15',plla.rowid,plla.attribute15) line_location_attribute15 from po_line_locations_all plla, mtl_parameters mp, hr_locations_all hla where plla.ship_to_location_id=hla.location_id(+) and plla.ship_to_organization_id=mp.organization_id(+) and plla.po_release_id is null ) select null action_, null status_, null message_, null modified_columns_, pha.org_id, to_number(null) request_id_, to_number(null) interface_header_id, pha.po_header_id, pha.segment1 po_number, null group_, null document_number, pha.revision_num, pha.creation_date, pt.document_type_name document_type, po_headers_sv3.get_po_status(pha.po_header_id) document_status, pha.start_date effective_start_date, pha.end_date effective_end_date, pha.currency_code, gdct.user_conversion_type rate_type, pha.rate_date, pha.rate, pha.reference_num header_reference_num, pha.comments header_description, papf.full_name buyer, pv.vendor_name supplier_name, pvsa.vendor_site_code supplier_site, pha.blanket_total_amount amount_agreed, xxen_util.meaning(pha.global_agreement_flag,'YES_NO',0) global_agreement, pha.quote_warning_delay, pha.note_to_vendor header_note_to_vendor, pha.note_to_receiver header_note_to_receiver, xxen_util.display_flexfield_context(201,'PO_HEADERS',pha.attribute_category) header_dff_context, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE1',pha.rowid,pha.attribute1) header_attribute1, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE2',pha.rowid,pha.attribute2) header_attribute2, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE3',pha.rowid,pha.attribute3) header_attribute3, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE4',pha.rowid,pha.attribute4) header_attribute4, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE5',pha.rowid,pha.attribute5) header_attribute5, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE6',pha.rowid,pha.attribute6) header_attribute6, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE7',pha.rowid,pha.attribute7) header_attribute7, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE8',pha.rowid,pha.attribute8) header_attribute8, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE9',pha.rowid,pha.attribute9) header_attribute9, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE10',pha.rowid,pha.attribute10) header_attribute10, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE11',pha.rowid,pha.attribute11) header_attribute11, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE12',pha.rowid,pha.attribute12) header_attribute12, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE13',pha.rowid,pha.attribute13) header_attribute13, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE14',pha.rowid,pha.attribute14) header_attribute14, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE15',pha.rowid,pha.attribute15) header_attribute15, hla2.location_code header_ship_to_location, hla1.location_code header_bill_to_location, to_number(null) interface_line_id, pl.po_line_id, pl.line_num, pl.line_reference_num, pl.line_type, pl.item, pl.item_revision, pl.category, pl.description, pl.unit_of_measure, pl.unit_price price, pl.allow_price_override, pl.limit_price, pl.line_quantity, pl.supplier_item, pl.note_to_vendor line_note_to_vendor, pl.line_dff_context, pl.line_attribute1, pl.line_attribute2, pl.line_attribute3, pl.line_attribute4, pl.line_attribute5, pl.line_attribute6, pl.line_attribute7, pl.line_attribute8, pl.line_attribute9, pl.line_attribute10, pl.line_attribute11, pl.line_attribute12, pl.line_attribute13, pl.line_attribute14, pl.line_attribute15, to_number(null) interface_line_location_id, pll.line_location_id, pll.shipment_num, pll.ship_quantity, pll.break_price, pll.break_unit_of_measure, --pll.discount, pll.ship_to_organization_code, pll.ship_to_location_code, pll.need_by_date, pll.promised_date, pll.price_break_start_date, pll.price_break_end_date, pll.line_location_dff_context, pll.line_location_attribute1, pll.line_location_attribute2, pll.line_location_attribute3, pll.line_location_attribute4, pll.line_location_attribute5, pll.line_location_attribute6, pll.line_location_attribute7, pll.line_location_attribute8, pll.line_location_attribute9, pll.line_location_attribute10, pll.line_location_attribute11, pll.line_location_attribute12, pll.line_location_attribute13, pll.line_location_attribute14, pll.line_location_attribute15, to_number(null) interface_distribution_id, pda.po_distribution_id, pda.distribution_num, pda.quantity_ordered, gcck.concatenated_segments charge_account, case when pda.deliver_to_person_id is not null then (select papf.full_name from per_all_people_f papf where papf.person_id=pda.deliver_to_person_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date) end requestor, case when pda.project_id is not null then (select ppev.project_number from pa_projects_expend_v ppev where ppev.project_id=pda.project_id) end project_number, case when pda.task_id is not null then (select ptaev.task_number from pa_tasks_all_expend_v ptaev where ptaev.task_id= pda.task_id and ptaev.expenditure_org_id=pda.org_id) end task_number, pda.expenditure_type, pda.expenditure_item_date expenditure_date, case when pda.expenditure_organization_id is not null then (select poev.name from pa_organizations_expend_v poev where poev.organization_id= pda.expenditure_organization_id) end expenditure_org, xxen_util.display_flexfield_context(201,'PO_DISTRIBUTIONS',pda.attribute_category) distribution_dff_context, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE1',pda.rowid,pda.attribute1) distribution_attribute1, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE2',pda.rowid,pda.attribute2) distribution_attribute2, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE3',pda.rowid,pda.attribute3) distribution_attribute3, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE4',pda.rowid,pda.attribute4) distribution_attribute4, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE5',pda.rowid,pda.attribute5) distribution_attribute5, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE6',pda.rowid,pda.attribute6) distribution_attribute6, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE7',pda.rowid,pda.attribute7) distribution_attribute7, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE8',pda.rowid,pda.attribute8) distribution_attribute8, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE9',pda.rowid,pda.attribute9) distribution_attribute9, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE10',pda.rowid,pda.attribute10) distribution_attribute10, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE11',pda.rowid,pda.attribute11) distribution_attribute11, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE12',pda.rowid,pda.attribute12) distribution_attribute12, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE13',pda.rowid,pda.attribute13) distribution_attribute13, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE14',pda.rowid,pda.attribute14) distribution_attribute14, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE15',pda.rowid,pda.attribute15) distribution_attribute15, null approval_status, null create_or_update_items, null group_lines, null attachment_category_, null attachment_title_, null attachment_description_, null attachment_type_, null attachment_content_, null attachment_file_id_ from po_headers_all pha, gl_daily_conversion_types gdct, per_all_people_f papf, po_vendors pv, po_vendor_sites_all pvsa, hr_locations_all hla1, hr_locations_all hla2, po_distributions_all pda, gl_code_combinations_kfv gcck, hr_all_organization_units_vl haouv, document_types_ pt, po_lines_ pl, po_line_locations_ pll where nvl(:p_create_empty_file,'N')<>'Y' and 1=1 and 2=2 and pha.org_id=haouv.organization_id and pha.rate_type=gdct.conversion_type(+) and pha.type_lookup_code=pt.document_type and papf.person_id=pha.agent_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and pha.vendor_id=pv.vendor_id(+) and pha.vendor_site_id=pvsa.vendor_site_id(+) and pha.bill_to_location_id=hla1.location_id(+) and pha.ship_to_location_id=hla2.location_id(+) and pha.po_header_id=pl.po_header_id(+) and pl.po_line_id=pll.po_line_id(+) and pll.line_location_id=pda.line_location_id(+) and pda.code_combination_id=gcck.code_combination_id(+) and nvl(pha.cancel_flag,'N')='N' and nvl(pha.closed_code,'OPEN')='OPEN' and nvl(pha.frozen_flag,'N')='N' and nvl(pha.user_hold_flag,'N')='N' U A xxen_po_upload.create_update_purchase_docs US Ashish test upload 141025 1=1 2=2 3=3 :p_create_empty_file 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 5 ORG_ID Number number 6 REQUEST_ID_ Number number 7 INTERFACE_HEADER_ID Number number 8 PO_HEADER_ID Number number 9 PO_NUMBER Char varchar2 10 GROUP_ Char varchar2 11 DOCUMENT_NUMBER Char varchar2 12 REVISION_NUM Number number 13 CREATION_DATE Date date 14 DOCUMENT_TYPE Char varchar2 15 DOCUMENT_STATUS Char varchar2 16 EFFECTIVE_START_DATE Date date 17 EFFECTIVE_END_DATE Date date 18 CURRENCY_CODE Char varchar2 19 RATE_TYPE Char varchar2 20 RATE_DATE Date date 21 RATE Number number 22 HEADER_REFERENCE_NUM Char varchar2 23 HEADER_DESCRIPTION Char varchar2 24 BUYER Char varchar2 25 SUPPLIER_NAME Char varchar2 26 SUPPLIER_SITE Char varchar2 27 AMOUNT_AGREED Number number 28 GLOBAL_AGREEMENT Char varchar2 29 QUOTE_WARNING_DELAY Number number 30 HEADER_NOTE_TO_VENDOR Char varchar2 31 HEADER_NOTE_TO_RECEIVER Char varchar2 32 HEADER_DFF_CONTEXT Char varchar2 33 HEADER_ATTRIBUTE1 Char varchar2 34 HEADER_ATTRIBUTE2 Char varchar2 35 HEADER_ATTRIBUTE3 Char varchar2 36 HEADER_ATTRIBUTE4 Char varchar2 37 HEADER_ATTRIBUTE5 Char varchar2 38 HEADER_ATTRIBUTE6 Char varchar2 39 HEADER_ATTRIBUTE7 Char varchar2 40 HEADER_ATTRIBUTE8 Char varchar2 41 HEADER_ATTRIBUTE9 Char varchar2 42 HEADER_ATTRIBUTE10 Char varchar2 43 HEADER_ATTRIBUTE11 Char varchar2 44 HEADER_ATTRIBUTE12 Char varchar2 45 HEADER_ATTRIBUTE13 Char varchar2 46 HEADER_ATTRIBUTE14 Char varchar2 47 HEADER_ATTRIBUTE15 Char varchar2 48 HEADER_SHIP_TO_LOCATION Char varchar2 49 HEADER_BILL_TO_LOCATION Char varchar2 50 INTERFACE_LINE_ID Number number 51 PO_LINE_ID Number number 52 LINE_NUM Number number 53 LINE_REFERENCE_NUM Char varchar2 54 LINE_TYPE Char varchar2 55 ITEM Char varchar2 56 ITEM_REVISION Char varchar2 57 CATEGORY Char varchar2 58 DESCRIPTION Char varchar2 59 UNIT_OF_MEASURE Char varchar2 60 PRICE Number number 61 ALLOW_PRICE_OVERRIDE Char varchar2 62 LIMIT_PRICE Number number 63 LINE_QUANTITY Number number 64 SUPPLIER_ITEM Char varchar2 65 LINE_NOTE_TO_VENDOR Char varchar2 66 LINE_DFF_CONTEXT Char varchar2 67 LINE_ATTRIBUTE1 Char varchar2 68 LINE_ATTRIBUTE2 Char varchar2 69 LINE_ATTRIBUTE3 Char varchar2 70 LINE_ATTRIBUTE4 Char varchar2 71 LINE_ATTRIBUTE5 Char varchar2 72 LINE_ATTRIBUTE6 Char varchar2 73 LINE_ATTRIBUTE7 Char varchar2 74 LINE_ATTRIBUTE8 Char varchar2 75 LINE_ATTRIBUTE9 Char varchar2 76 LINE_ATTRIBUTE10 Char varchar2 77 LINE_ATTRIBUTE11 Char varchar2 78 LINE_ATTRIBUTE12 Char varchar2 79 LINE_ATTRIBUTE13 Char varchar2 80 LINE_ATTRIBUTE14 Char varchar2 81 LINE_ATTRIBUTE15 Char varchar2 82 INTERFACE_LINE_LOCATION_ID Number number 83 LINE_LOCATION_ID Number number 84 SHIPMENT_NUM Number number 85 SHIP_QUANTITY Number number 86 BREAK_PRICE Number number 87 BREAK_UNIT_OF_MEASURE Char varchar2 88 SHIP_TO_ORGANIZATION_CODE Char varchar2 89 SHIP_TO_LOCATION_CODE Char varchar2 90 NEED_BY_DATE Date date 91 PROMISED_DATE Date date 92 PRICE_BREAK_START_DATE Date date 93 PRICE_BREAK_END_DATE Date date 94 LINE_LOCATION_DFF_CONTEXT Char varchar2 95 LINE_LOCATION_ATTRIBUTE1 Char varchar2 96 LINE_LOCATION_ATTRIBUTE2 Char varchar2 97 LINE_LOCATION_ATTRIBUTE3 Char varchar2 98 LINE_LOCATION_ATTRIBUTE4 Char varchar2 99 LINE_LOCATION_ATTRIBUTE5 Char varchar2 100 LINE_LOCATION_ATTRIBUTE6 Char varchar2 101 LINE_LOCATION_ATTRIBUTE7 Char varchar2 102 LINE_LOCATION_ATTRIBUTE8 Char varchar2 103 LINE_LOCATION_ATTRIBUTE9 Char varchar2 104 LINE_LOCATION_ATTRIBUTE10 Char varchar2 105 LINE_LOCATION_ATTRIBUTE11 Char varchar2 106 LINE_LOCATION_ATTRIBUTE12 Char varchar2 107 LINE_LOCATION_ATTRIBUTE13 Char varchar2 108 LINE_LOCATION_ATTRIBUTE14 Char varchar2 109 LINE_LOCATION_ATTRIBUTE15 Char varchar2 110 INTERFACE_DISTRIBUTION_ID Number number 111 PO_DISTRIBUTION_ID Number number 112 DISTRIBUTION_NUM Number number 113 QUANTITY_ORDERED Number number 114 CHARGE_ACCOUNT Char varchar2 115 REQUESTOR Char varchar2 116 PROJECT_NUMBER Char varchar2 117 TASK_NUMBER Char varchar2 118 EXPENDITURE_TYPE Char varchar2 119 EXPENDITURE_DATE Date date 120 EXPENDITURE_ORG Char varchar2 121 DISTRIBUTION_DFF_CONTEXT Char varchar2 122 DISTRIBUTION_ATTRIBUTE1 Char varchar2 123 DISTRIBUTION_ATTRIBUTE2 Char varchar2 124 DISTRIBUTION_ATTRIBUTE3 Char varchar2 125 DISTRIBUTION_ATTRIBUTE4 Char varchar2 126 DISTRIBUTION_ATTRIBUTE5 Char varchar2 127 DISTRIBUTION_ATTRIBUTE6 Char varchar2 128 DISTRIBUTION_ATTRIBUTE7 Char varchar2 129 DISTRIBUTION_ATTRIBUTE8 Char varchar2 130 DISTRIBUTION_ATTRIBUTE9 Char varchar2 131 DISTRIBUTION_ATTRIBUTE10 Char varchar2 132 DISTRIBUTION_ATTRIBUTE11 Char varchar2 133 DISTRIBUTION_ATTRIBUTE12 Char varchar2 134 DISTRIBUTION_ATTRIBUTE13 Char varchar2 135 DISTRIBUTION_ATTRIBUTE14 Char varchar2 136 DISTRIBUTION_ATTRIBUTE15 Char varchar2 137 APPROVAL_STATUS Char varchar2 138 CREATE_OR_UPDATE_ITEMS Char varchar2 139 GROUP_LINES Char varchar2 140 ATTACHMENT_CATEGORY_ Char varchar2 141 ATTACHMENT_TITLE_ Char varchar2 142 ATTACHMENT_DESCRIPTION_ Char varchar2 143 ATTACHMENT_TYPE_ Char varchar2 144 ATTACHMENT_CONTENT_ Char varchar2 145 ATTACHMENT_FILE_ID_ Char varchar2 U 1 p_org_id in Number ORG_ID U 2 p_po_number in Char Y PO_NUMBER U 3 p_po_group_code in Char Y U 4 p_document_number in Char Y DOCUMENT_NUMBER U 5 p_revision_number in Char Y REVISION_NUM U 6 p_document_type_code in Char DOCUMENT_TYPE U 7 p_effective_start_date in Date EFFECTIVE_START_DATE U 8 p_effective_end_date in Date EFFECTIVE_END_DATE U 9 p_currency_code in Char CURRENCY_CODE U 10 p_agent_name in Char PROJECT_NUMBER U 11 p_vendor_name in Char U 12 p_vendor_site_code in Char U 13 p_header_ship_to_location in Char HEADER_SHIP_TO_LOCATION U 14 p_header_bill_to_location in Char HEADER_BILL_TO_LOCATION U 15 p_header_reference_num in Char HEADER_REFERENCE_NUM U 16 p_comments in Char U 17 p_amount_agreed in Number AMOUNT_AGREED U 18 p_quote_warning_delay in Number QUOTE_WARNING_DELAY U 19 p_header_note_to_vendor in Char HEADER_NOTE_TO_VENDOR U 20 p_header_note_to_receiver in Char HEADER_NOTE_TO_RECEIVER U 21 p_rate_type in Char RATE_TYPE U 22 p_rate_date in Date RATE_DATE U 23 p_rate in Number RATE U 24 p_global_agreement in Char GLOBAL_AGREEMENT U 25 p_supply_agreement_flag in Char U 26 p_creation_date in Date CREATION_DATE U 27 p_header_dff_context in Char HEADER_DFF_CONTEXT U 28 p_header_attribute1 in Char HEADER_ATTRIBUTE1 U 29 p_header_attribute2 in Char HEADER_ATTRIBUTE2 U 30 p_header_attribute3 in Char HEADER_ATTRIBUTE3 U 31 p_header_attribute4 in Char HEADER_ATTRIBUTE4 U 32 p_header_attribute5 in Char HEADER_ATTRIBUTE5 U 33 p_header_attribute6 in Char HEADER_ATTRIBUTE6 U 34 p_header_attribute7 in Char HEADER_ATTRIBUTE7 U 35 p_header_attribute8 in Char HEADER_ATTRIBUTE8 U 36 p_header_attribute9 in Char HEADER_ATTRIBUTE9 U 37 p_header_attribute10 in Char HEADER_ATTRIBUTE10 U 38 p_header_attribute11 in Char HEADER_ATTRIBUTE11 U 39 p_header_attribute12 in Char HEADER_ATTRIBUTE12 U 40 p_header_attribute13 in Char HEADER_ATTRIBUTE13 U 41 p_header_attribute14 in Char HEADER_ATTRIBUTE14 U 42 p_header_attribute15 in Char HEADER_ATTRIBUTE15 U 43 p_line_num in Number LINE_NUM U 44 p_line_reference_num in Char LINE_REFERENCE_NUM U 45 p_shipment_num in Number SHIPMENT_NUM U 46 p_line_type in Char LINE_TYPE U 47 p_item in Char ITEM U 48 p_item_revision in Char ITEM_REVISION U 49 p_item_category in Char CATEGORY U 50 p_item_description in Char HEADER_DESCRIPTION U 51 p_unit_of_measure in Char UNIT_OF_MEASURE U 52 p_supplier_item in Char SUPPLIER_ITEM U 53 p_quantity in Number SHIP_QUANTITY U 54 p_unit_price in Number LIMIT_PRICE U 55 p_allow_price_override in Char ALLOW_PRICE_OVERRIDE U 56 p_limit_price in Number LIMIT_PRICE U 57 p_ship_to_organization in Char SHIP_TO_ORGANIZATION_CODE U 58 p_ship_to_location in Char HEADER_SHIP_TO_LOCATION U 59 p_line_note_to_vendor in Char LINE_NOTE_TO_VENDOR U 60 p_line_dff_context in Char LINE_DFF_CONTEXT U 61 p_line_attribute1 in Char LINE_ATTRIBUTE1 U 62 p_line_attribute2 in Char LINE_ATTRIBUTE2 U 63 p_line_attribute3 in Char LINE_ATTRIBUTE3 U 64 p_line_attribute4 in Char LINE_ATTRIBUTE4 U 65 p_line_attribute5 in Char LINE_ATTRIBUTE5 U 66 p_line_attribute6 in Char LINE_ATTRIBUTE6 U 67 p_line_attribute7 in Char LINE_ATTRIBUTE7 U 68 p_line_attribute8 in Char LINE_ATTRIBUTE8 U 69 p_line_attribute9 in Char LINE_ATTRIBUTE9 U 70 p_line_attribute10 in Char LINE_ATTRIBUTE10 U 71 p_line_attribute11 in Char LINE_ATTRIBUTE11 U 72 p_line_attribute12 in Char LINE_ATTRIBUTE12 U 73 p_line_attribute13 in Char LINE_ATTRIBUTE13 U 74 p_line_attribute14 in Char LINE_ATTRIBUTE14 U 75 p_line_attribute15 in Char LINE_ATTRIBUTE15 U 76 p_need_by_date in Date NEED_BY_DATE U 77 p_promised_date in Date PROMISED_DATE U 78 p_ship_quantity in Number SHIP_QUANTITY U 79 p_price_override in Number ALLOW_PRICE_OVERRIDE U 80 p_price_break_uom in Char PRICE_BREAK_END_DATE U 81 p_price_break_start_date in Date PRICE_BREAK_START_DATE U 82 p_price_break_end_date in Date PRICE_BREAK_END_DATE U 83 p_line_location_dff_context in Char LINE_LOCATION_DFF_CONTEXT U 84 p_line_location_attribute1 in Char LINE_LOCATION_ATTRIBUTE1 U 85 p_line_location_attribute2 in Char LINE_LOCATION_ATTRIBUTE2 U 86 p_line_location_attribute3 in Char LINE_LOCATION_ATTRIBUTE3 U 87 p_line_location_attribute4 in Char LINE_LOCATION_ATTRIBUTE4 U 88 p_line_location_attribute5 in Char LINE_LOCATION_ATTRIBUTE5 U 89 p_line_location_attribute6 in Char LINE_LOCATION_ATTRIBUTE6 U 90 p_line_location_attribute7 in Char LINE_LOCATION_ATTRIBUTE7 U 91 p_line_location_attribute8 in Char LINE_LOCATION_ATTRIBUTE8 U 92 p_line_location_attribute9 in Char LINE_LOCATION_ATTRIBUTE9 U 93 p_line_location_attribute10 in Char LINE_LOCATION_ATTRIBUTE10 U 94 p_line_location_attribute11 in Char LINE_LOCATION_ATTRIBUTE11 U 95 p_line_location_attribute12 in Char LINE_LOCATION_ATTRIBUTE12 U 96 p_line_location_attribute13 in Char LINE_LOCATION_ATTRIBUTE13 U 97 p_line_location_attribute14 in Char LINE_LOCATION_ATTRIBUTE14 U 98 p_line_location_attribute15 in Char LINE_LOCATION_ATTRIBUTE15 U 99 p_distribution_num in Number DISTRIBUTION_NUM U 100 p_quantity_ordered in Number QUANTITY_ORDERED U 101 p_charge_account_id in Number CHARGE_ACCOUNT U 102 p_deliver_to_person in Char U 103 p_project_id in Number U 104 p_task_id in Number PO_HEADER_ID U 105 p_award_number in Char PO_NUMBER U 106 p_expenditure_type in Char EXPENDITURE_TYPE U 107 p_expenditure_organization_id in Number EXPENDITURE_ORG U 108 p_expenditure_item_date in Date EXPENDITURE_DATE U 109 p_project_related_flag in Char U 110 p_oke_contract_line_num in Char U 111 p_oke_contract_deliverable_num in Char U 112 p_end_item_unit_number in Char DOCUMENT_NUMBER U 113 p_distribution_dff_context in Char DISTRIBUTION_DFF_CONTEXT U 114 p_distribution_attribute1 in Char DISTRIBUTION_ATTRIBUTE1 U 115 p_distribution_attribute2 in Char DISTRIBUTION_ATTRIBUTE2 U 116 p_distribution_attribute3 in Char DISTRIBUTION_ATTRIBUTE3 U 117 p_distribution_attribute4 in Char DISTRIBUTION_ATTRIBUTE4 U 118 p_distribution_attribute5 in Char DISTRIBUTION_ATTRIBUTE5 U 119 p_distribution_attribute6 in Char DISTRIBUTION_ATTRIBUTE6 U 120 p_distribution_attribute7 in Char DISTRIBUTION_ATTRIBUTE7 U 121 p_distribution_attribute8 in Char DISTRIBUTION_ATTRIBUTE8 U 122 p_distribution_attribute9 in Char DISTRIBUTION_ATTRIBUTE9 U 123 p_distribution_attribute10 in Char DISTRIBUTION_ATTRIBUTE10 U 124 p_distribution_attribute11 in Char DISTRIBUTION_ATTRIBUTE11 U 125 p_distribution_attribute12 in Char DISTRIBUTION_ATTRIBUTE12 U 126 p_distribution_attribute13 in Char DISTRIBUTION_ATTRIBUTE13 U 127 p_distribution_attribute14 in Char DISTRIBUTION_ATTRIBUTE14 U 128 p_distribution_attribute15 in Char DISTRIBUTION_ATTRIBUTE15 U 129 p_receiving_routing_id in Number Y U 130 p_interface_header_id in/out Number INTERFACE_HEADER_ID U 131 p_interface_line_id in/out Number INTERFACE_LINE_ID U 132 p_interface_line_location_id in/out Number INTERFACE_LINE_LOCATION_ID U 133 p_interface_distribution_id in/out Number INTERFACE_DISTRIBUTION_ID U 134 p_po_header_id in/out Number PO_HEADER_ID U 135 p_po_line_id in/out Number PO_LINE_ID U 136 p_line_location_id in/out Number LINE_LOCATION_ID U 137 p_po_distribution_id in/out Number PO_DISTRIBUTION_ID U 138 status_ out Char STATUS_CODE_ U 139 message_ out Char MESSAGE_ Error SQL Success SQL