eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_INTERFACE_S dependencies on PO_LINES_INTERFACE

Line 314: po_lines_interface pli,

310: , pli.supplier_part_auxid supplier_part_auxid
311: , pli.catalog_name catalog_name
312: --
313: FROM po_headers_interface phi,
314: po_lines_interface pli,
315: po_distributions_interface pdi
316: WHERE phi.interface_header_id = pli.interface_header_id
317: AND pli.interface_line_id = pdi.interface_line_id
318: AND phi.interface_header_id = x_interface_header_id

Line 357: ** in the po_lines_interface table. Thie determines

353: g_rate_for_req_fields NUMBER; --
354: g_line_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE; --
355:
356: /* Global variable to hold number of req lines
357: ** in the po_lines_interface table. Thie determines
358: ** if we copy project_id, task_id from req to rfq
359: */
360: g_req_lines_to_process number:=0;
361:

Line 1101: update po_lines_interface pli

1097: -- and prl.auction_line_number<>pli.auction_line_number)" in the
1098: --following sql.
1099:
1100: l_progress:='060';
1101: update po_lines_interface pli
1102: set pli.requisition_line_id= null
1103: where pli.interface_header_id= x_interface_header_id
1104: and exists
1105: (select requisition_line_id

Line 1126: UPDATE po_lines_interface pli

1122: p_token => l_progress,
1123: p_message => 'Sourcing to PO FPH-1: before the update for withdrawn reqs');
1124: END IF;
1125:
1126: UPDATE po_lines_interface pli
1127: SET pli.requisition_line_id= null
1128: WHERE pli.interface_header_id= x_interface_header_id
1129: AND NOT EXISTS
1130: (SELECT requisition_line_id

Line 1153: FROM po_lines_interface

1149: * project/task reference from RFQ to Quote
1150: */
1151: SELECT count(*)
1152: INTO g_req_lines_to_process
1153: FROM po_lines_interface
1154: WHERE interface_header_id = x_interface_header_id;
1155:
1156: l_progress:='090';
1157:

Line 1586: from po_lines_interface

1582: END IF;
1583:
1584: select distinct 'Y'
1585: into X_line_found
1586: from po_lines_interface
1587: where interface_header_id = x_interface_header_id
1588: and line_num is not null;
1589:
1590: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 1593: p_message => 'Create PO : Line found in po_lines_interfaces');

1589:
1590: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
1591: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1592: p_token => l_progress,
1593: p_message => 'Create PO : Line found in po_lines_interfaces');
1594: END IF;
1595:
1596: EXCEPTION
1597: WHEN OTHERS THEN

Line 3094: l_quantity_in_ga_uom PO_LINES_INTERFACE.quantity%TYPE;

3090:
3091: -- Bug 2735840 START
3092: l_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
3093: l_ga_uom PO_LINES.unit_meas_lookup_code%TYPE;
3094: l_quantity_in_ga_uom PO_LINES_INTERFACE.quantity%TYPE;
3095: l_conversion_rate number :=1;
3096: -- Bug 2735840 END
3097:
3098: -- Bug 2875346.

Line 8502: l_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE;

8498: l_new_ccid_generated BOOLEAN := FALSE;
8499: l_FB_ERROR_MSG VARCHAR2(2000);
8500:
8501: l_return_status VARCHAR2(1);
8502: l_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE;
8503: l_old_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE := -1;
8504: l_interface_distribution_id PO_DISTRIBUTIONS_INTERFACE.interface_distribution_id%TYPE;
8505: l_item_category_id PO_LINES_INTERFACE.category_id%TYPE;
8506: l_req_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;

Line 8503: l_old_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE := -1;

8499: l_FB_ERROR_MSG VARCHAR2(2000);
8500:
8501: l_return_status VARCHAR2(1);
8502: l_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE;
8503: l_old_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE := -1;
8504: l_interface_distribution_id PO_DISTRIBUTIONS_INTERFACE.interface_distribution_id%TYPE;
8505: l_item_category_id PO_LINES_INTERFACE.category_id%TYPE;
8506: l_req_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
8507: l_req_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;

Line 8505: l_item_category_id PO_LINES_INTERFACE.category_id%TYPE;

8501: l_return_status VARCHAR2(1);
8502: l_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE;
8503: l_old_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE := -1;
8504: l_interface_distribution_id PO_DISTRIBUTIONS_INTERFACE.interface_distribution_id%TYPE;
8505: l_item_category_id PO_LINES_INTERFACE.category_id%TYPE;
8506: l_req_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
8507: l_req_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
8508: l_destination_organization_id PO_DISTRIBUTIONS_INTERFACE.destination_organization_id%TYPE;
8509: l_destination_ou_id PO_HEADERS_ALL.org_id%TYPE;

Line 8511: l_item_id PO_LINES_INTERFACE.item_id%TYPE;

8507: l_req_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
8508: l_destination_organization_id PO_DISTRIBUTIONS_INTERFACE.destination_organization_id%TYPE;
8509: l_destination_ou_id PO_HEADERS_ALL.org_id%TYPE;
8510:
8511: l_item_id PO_LINES_INTERFACE.item_id%TYPE;
8512: l_category_id PO_LINES_INTERFACE.category_id%TYPE;
8513: l_destination_type_code PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE;
8514: --l_ship_to_organization_id NUMBER;
8515: l_ship_to_location_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_location_id%TYPE;

Line 8512: l_category_id PO_LINES_INTERFACE.category_id%TYPE;

8508: l_destination_organization_id PO_DISTRIBUTIONS_INTERFACE.destination_organization_id%TYPE;
8509: l_destination_ou_id PO_HEADERS_ALL.org_id%TYPE;
8510:
8511: l_item_id PO_LINES_INTERFACE.item_id%TYPE;
8512: l_category_id PO_LINES_INTERFACE.category_id%TYPE;
8513: l_destination_type_code PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE;
8514: --l_ship_to_organization_id NUMBER;
8515: l_ship_to_location_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_location_id%TYPE;
8516: l_deliver_to_person_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_person_id%TYPE;

Line 8517: l_line_type_id PO_LINES_INTERFACE.line_type_id%TYPE;

8513: l_destination_type_code PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE;
8514: --l_ship_to_organization_id NUMBER;
8515: l_ship_to_location_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_location_id%TYPE;
8516: l_deliver_to_person_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_person_id%TYPE;
8517: l_line_type_id PO_LINES_INTERFACE.line_type_id%TYPE;
8518: l_vendor_id PO_VENDORS.vendor_id%TYPE;
8519: l_agent_id PO_HEADERS.agent_id%TYPE;
8520: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;
8521: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;

Line 8548: l_req_line_id PO_LINES_INTERFACE.requisition_line_id%TYPE;

8544: l_dest_variance_account_flex VARCHAR2(2000);
8545: --< New start_workflow parameters in FPJ End >
8546:
8547: -- Bug 3463242 START
8548: l_req_line_id PO_LINES_INTERFACE.requisition_line_id%TYPE;
8549: --
8550: l_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
8551: l_unit_price PO_LINES_INTERFACE.unit_price%TYPE;
8552: l_base_unit_price PO_LINES_INTERFACE.base_unit_price%TYPE;

Line 8551: l_unit_price PO_LINES_INTERFACE.unit_price%TYPE;

8547: -- Bug 3463242 START
8548: l_req_line_id PO_LINES_INTERFACE.requisition_line_id%TYPE;
8549: --
8550: l_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
8551: l_unit_price PO_LINES_INTERFACE.unit_price%TYPE;
8552: l_base_unit_price PO_LINES_INTERFACE.base_unit_price%TYPE;
8553: l_amount PO_LINES_INTERFACE.amount%TYPE;
8554: l_quantity_dummy PO_LINES_INTERFACE.quantity%TYPE;
8555: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;

Line 8552: l_base_unit_price PO_LINES_INTERFACE.base_unit_price%TYPE;

8548: l_req_line_id PO_LINES_INTERFACE.requisition_line_id%TYPE;
8549: --
8550: l_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
8551: l_unit_price PO_LINES_INTERFACE.unit_price%TYPE;
8552: l_base_unit_price PO_LINES_INTERFACE.base_unit_price%TYPE;
8553: l_amount PO_LINES_INTERFACE.amount%TYPE;
8554: l_quantity_dummy PO_LINES_INTERFACE.quantity%TYPE;
8555: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
8556: l_po_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE;

Line 8553: l_amount PO_LINES_INTERFACE.amount%TYPE;

8549: --
8550: l_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
8551: l_unit_price PO_LINES_INTERFACE.unit_price%TYPE;
8552: l_base_unit_price PO_LINES_INTERFACE.base_unit_price%TYPE;
8553: l_amount PO_LINES_INTERFACE.amount%TYPE;
8554: l_quantity_dummy PO_LINES_INTERFACE.quantity%TYPE;
8555: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
8556: l_po_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE;
8557: l_req_header_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;

Line 8554: l_quantity_dummy PO_LINES_INTERFACE.quantity%TYPE;

8550: l_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
8551: l_unit_price PO_LINES_INTERFACE.unit_price%TYPE;
8552: l_base_unit_price PO_LINES_INTERFACE.base_unit_price%TYPE;
8553: l_amount PO_LINES_INTERFACE.amount%TYPE;
8554: l_quantity_dummy PO_LINES_INTERFACE.quantity%TYPE;
8555: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
8556: l_po_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE;
8557: l_req_header_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;
8558: l_req_header_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE;

Line 8615: PO_LINES_INTERFACE pli,

8611: phi.rate,
8612: pdi.rate
8613: -- Bug 3463242 END
8614: FROM PO_DISTRIBUTIONS_INTERFACE pdi,
8615: PO_LINES_INTERFACE pli,
8616: PO_HEADERS_INTERFACE phi,
8617: PO_REQUISITION_LINES_ALL prl, --
8618: MTL_PARAMETERS mp,
8619: HR_ORGANIZATION_INFORMATION hoi,

Line 8945: UPDATE po_lines_interface

8941: END IF;
8942:
8943: IF l_interface_line_id <> l_old_interface_line_id THEN
8944: l_progress := '120';
8945: UPDATE po_lines_interface
8946: SET transaction_flow_header_id = l_transaction_flow_header_id
8947: WHERE interface_line_id = l_interface_line_id;
8948:
8949: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 9265: from po_lines_interface pli,

9261: pli.item_id,
9262: phi.vendor_id,
9263: phi.vendor_site_id,
9264: pdi.destination_organization_id
9265: from po_lines_interface pli,
9266: po_headers_interface phi,
9267: po_distributions_interface pdi
9268: where phi.interface_header_id = x_interface_header_id
9269: and phi.interface_header_id = pli.interface_header_id

Line 9296: FROM po_lines_interface pli,

9292: phi.rate,
9293: phi.rate_date,
9294: phi.document_subtype,
9295: pli.unit_price --
9296: FROM po_lines_interface pli,
9297: po_headers_interface phi,
9298: po_line_types plt
9299: WHERE phi.interface_header_id = x_interface_header_id
9300: AND phi.interface_header_id = pli.interface_header_id

Line 9320: -- the requisition line id would be null in po_lines_interface .

9316: -- If the line is OPM item with dual uom control then the shipment corresponding
9317: -- to the extra PO line created by Sourcing does not have secondary uom and
9318: -- secondary quantity with ship to organization as process org.
9319: -- default secondary UOM and secondary quantity in such a case (non req backed lines)
9320: -- the requisition line id would be null in po_lines_interface .
9321: -- need to handle that situation in the default_opm_attributes cursor.
9322: -- in case of non req back lines from sourcing , ship_to_organization_id is NULL.
9323: -- so get it from distribution interface table.
9324:

Line 9572: FROM po_lines_interface pli,

9568: l_progress:='090';
9569:
9570: SELECT min(interface_line_id)
9571: INTO x_min_interface_line_id
9572: FROM po_lines_interface pli,
9573: po_headers_interface phi
9574: WHERE phi.interface_header_id=pli.interface_header_id
9575: AND phi.interface_header_id = x_interface_header_id;
9576:

Line 9694: po_lines_interface pli

9690: null),
9691: phi.document_subtype,
9692: l_shipping_control --
9693: FROM po_headers_interface phi2,
9694: po_lines_interface pli
9695: WHERE phi2.interface_header_id = phi.interface_header_id
9696: AND pli.interface_header_id=phi2.interface_header_id
9697: AND pli.interface_line_id = x_min_interface_line_id)
9698: WHERE interface_header_id = x_interface_header_id;

Line 9753: UPDATE po_lines_interface pli2

9749: -- for x_uom_convert, since UOM checking is now handled in
9750: -- source_blanket_line.
9751:
9752: l_progress:='120';
9753: UPDATE po_lines_interface pli2
9754: SET (
9755: line_num,
9756: item_id,
9757: category_id,

Line 9857: FROM po_lines_interface pli,

9853: nvl(pli.preferred_grade,prl.preferred_grade),
9854: -- end of 1548597
9855: prl.drop_ship_flag, --
9856: prl.vmi_flag -- VMI FPH
9857: FROM po_lines_interface pli,
9858: po_headers_interface phi,
9859: po_requisition_lines_all prl, --
9860: po_line_types plt,
9861: po_lines_all pol --

Line 9886: UPDATE po_lines_interface pli

9882: /* CONSIGNED FPI Start */
9883: ELSE -- CONSIGNED FPI
9884: l_progress:='130';
9885: -- bug 6636486 modified the below update sql to increase the performance.
9886: UPDATE po_lines_interface pli
9887: SET pli.po_header_id = x_po_header_id,
9888: pli.negotiated_by_preparer_flag = nvl(pli.negotiated_by_preparer_flag,'N'),
9889: pli.firm_flag = nvl(pli.firm_flag, 'N')
9890: WHERE pli.interface_header_id = x_interface_header_id;

Line 9900: FROM po_lines_interface pli,

9896: /*(SELECT
9897: x_po_header_id,
9898: nvl(pli.negotiated_by_preparer_flag,'N'),
9899: nvl(pli.firm_flag,'N')
9900: FROM po_lines_interface pli,
9901: po_headers_interface phi
9902: WHERE pli.interface_line_id = pli2.interface_line_id
9903: AND pli.interface_header_id = phi.interface_header_id
9904: AND phi.interface_header_id = x_interface_header_id);*/

Line 9938: UPDATE po_lines_interface pli2

9934: -- Added note_to_vendor - iali 08/26/99
9935: /*Bug 1391523 . Added market price to the update statement */
9936:
9937: l_progress:='150';
9938: UPDATE po_lines_interface pli2
9939: SET (
9940: line_num,
9941: item_id,
9942: job_id, --

Line 10061: FROM po_lines_interface pli,

10057: nvl(pli.contractor_first_name, prl.candidate_first_name),
10058: nvl(pli.contractor_last_name, prl.candidate_last_name)
10059: --
10060: ,pol.supplier_part_auxid --13876074
10061: FROM po_lines_interface pli,
10062: po_headers_interface phi,
10063: po_requisition_lines_all prl, --
10064: po_line_types plt
10065: ,po_lines_all pol --13876074

Line 10211: po_lines_interface pli,

10207: decode(pli.consigned_flag,'Y',null,
10208: prd.oke_contract_deliverable_id)
10209: FROM po_requisition_lines_all prl, --
10210: po_req_distributions_all prd, --
10211: po_lines_interface pli,
10212: po_headers_interface phi
10213: WHERE prd.requisition_line_id = prl.requisition_line_id
10214: AND prl.requisition_line_id = pli.requisition_line_id -- Bug:1563888
10215: AND pli.interface_header_id = phi.interface_header_id

Line 10398: update po_lines_interface

10394: x_vendor_product_num,
10395: x_purchasing_uom);
10396:
10397: if (x_vendor_product_num is not null) then
10398: update po_lines_interface
10399: set vendor_product_num = x_vendor_product_num
10400: where rowid = x_rowid;
10401:
10402: end if;

Line 10468: DELETE po_lines_interface

10464: DELETE po_line_locations_interface
10465: WHERE interface_header_id = x_interface_header_id;
10466: --
10467:
10468: DELETE po_lines_interface
10469: WHERE interface_header_id = x_interface_header_id;
10470:
10471:
10472: DELETE po_headers_interface

Line 10538: x_vmi_flag PO_LINES_INTERFACE.VMI_FLAG%TYPE; /* VMI FPH */

10534: x_bid_line_number number;
10535: x_row_id varchar2(25) := null;
10536: --
10537:
10538: x_vmi_flag PO_LINES_INTERFACE.VMI_FLAG%TYPE; /* VMI FPH */
10539: x_drop_ship_flag PO_LINES_INTERFACE.DROP_SHIP_FLAG%TYPE; --
10540:
10541: x_source_doc_id number; -- FPI GA
10542: x_source_doc_line_id number; -- FPI GA

Line 10539: x_drop_ship_flag PO_LINES_INTERFACE.DROP_SHIP_FLAG%TYPE; --

10535: x_row_id varchar2(25) := null;
10536: --
10537:
10538: x_vmi_flag PO_LINES_INTERFACE.VMI_FLAG%TYPE; /* VMI FPH */
10539: x_drop_ship_flag PO_LINES_INTERFACE.DROP_SHIP_FLAG%TYPE; --
10540:
10541: x_source_doc_id number; -- FPI GA
10542: x_source_doc_line_id number; -- FPI GA
10543:

Line 10546: l_supplier_ref_number PO_LINES_INTERFACE.supplier_ref_number%TYPE; --

10542: x_source_doc_line_id number; -- FPI GA
10543:
10544: x_consigned_flag VARCHAR2(1) := 'N'; --CONSIGNED FPI
10545: x_create_new_line VARCHAR2(1) := 'N'; --GA FPI
10546: l_supplier_ref_number PO_LINES_INTERFACE.supplier_ref_number%TYPE; --
10547:
10548: l_contract_id PO_LINES_ALL.contract_id%TYPE; --
10549:
10550: /* Bug 3201308 start */

Line 10576: FROM po_lines_interface pli

10572:
10573: /* Bug 1949160. Created a cursor to retrieve requisition line-id */
10574: CURSOR interface_lines_temp IS
10575: SELECT pli.requisition_line_id
10576: FROM po_lines_interface pli
10577: WHERE pli.interface_header_id = x_interface_header_id
10578: -- bug 4000047: start: requisition lines should be entered
10579: -- into PO the same order they appear in the requisition
10580: ORDER BY pli.requisition_line_id;

Line 10612: FROM po_lines_interface pli,

10608: pli.from_line_id, -- FPI GA
10609: pli.consigned_flag, -- CONSIGNED FPI
10610: pli.contract_id, --
10611: pli.supplier_ref_number --
10612: FROM po_lines_interface pli,
10613: po_distributions_interface pld
10614: WHERE pli.interface_header_id=x_interface_header_id
10615: AND pli.interface_line_id=pld.interface_line_id
10616: AND pld.interface_distribution_id =

Line 10705: UPDATE po_lines_interface pli

10701: -- use requisition numbers
10702:
10703: l_progress:='035';
10704:
10705: UPDATE po_lines_interface pli
10706: SET pli.shipment_num = 1,
10707: pli.line_num =
10708: (
10709: SELECT prl.line_num

Line 10733: UPDATE po_lines_interface pli

10729: EXIT WHEN interface_lines_temp%NOTFOUND;
10730:
10731: l_progress := '050';
10732:
10733: UPDATE po_lines_interface pli
10734: SET pli.line_num = x_count,
10735: pli.shipment_num = 1
10736: WHERE pli.requisition_line_id = x_requisition_line_id
10737: AND pli.interface_header_id = x_interface_header_id

Line 10833: FROM po_lines_interface pli

10829: SELECT MIN(pli.line_num),
10830: pli.po_line_id
10831: INTO x_po_line_num,
10832: x_po_line_id
10833: FROM po_lines_interface pli
10834: WHERE pli.interface_header_id = x_interface_header_id
10835: AND pli.line_num IS NOT NULL
10836: AND pli.line_type_id = x_line_type_id
10837: AND NVL(pli.item_id, -1) = NVL(x_item_id, -1)

Line 10880: UPDATE po_lines_interface pli

10876: p_token => l_progress,
10877: p_message => 'Group_interface_lines progress is :'|| l_progress);
10878: END IF; -- debug logging
10879:
10880: UPDATE po_lines_interface pli
10881: SET pli.line_num = x_po_line_num
10882: WHERE pli.interface_header_id = x_interface_header_id
10883: AND pli.requisition_line_id = x_requisition_line_id;
10884:

Line 10903: UPDATE po_lines_interface pli

10899: -- use requisition numbers
10900:
10901: l_progress := '100';
10902:
10903: UPDATE po_lines_interface pli
10904: SET pli.shipment_num =
10905: ( SELECT prl.line_num
10906: FROM po_requisition_lines_all prl
10907: WHERE prl.requisition_line_id = pli.requisition_line_id )

Line 10925: UPDATE po_lines_interface pli

10921: EXIT WHEN interface_lines_temp%NOTFOUND;
10922:
10923: l_progress := '110';
10924:
10925: UPDATE po_lines_interface pli
10926: SET pli.shipment_num = x_count
10927: WHERE pli.requisition_line_id = x_requisition_line_id
10928: AND pli.interface_header_id = x_interface_header_id
10929: AND pli.shipment_num IS NULL;

Line 10984: UPDATE po_lines_interface pli

10980: EXIT WHEN interface_lines_temp%NOTFOUND;
10981:
10982: l_progress := '150';
10983:
10984: UPDATE po_lines_interface pli
10985: SET pli.line_num = x_line_num + x_count,
10986: pli.shipment_num = 1
10987: WHERE pli.requisition_line_id = x_requisition_line_id
10988: AND pli.interface_header_id = x_interface_header_id

Line 11086: FROM po_lines_interface pli

11082: SELECT MIN(pli.line_num),
11083: pli.po_line_id
11084: INTO x_po_line_num,
11085: x_po_line_id
11086: FROM po_lines_interface pli
11087: WHERE pli.interface_header_id = x_interface_header_id
11088: AND pli.line_num IS NOT NULL
11089: AND pli.line_type_id = x_line_type_id
11090: AND NVL(pli.item_id, -1) = NVL(x_item_id, -1)

Line 11130: UPDATE po_lines_interface pli

11126: p_token => l_progress,
11127: p_message => 'Group_interface_lines: Line_num is :'|| x_po_line_num);
11128: END IF;
11129:
11130: UPDATE po_lines_interface pli
11131: SET pli.line_num = x_po_line_num
11132: WHERE pli.interface_header_id = x_interface_header_id
11133: AND pli.requisition_line_id = x_requisition_line_id;
11134:

Line 11179: -- statement and now updating the po_lines_interface in a loop using

11175: -- Prior to this fix, for Releases, the shipment number was
11176: -- derived by adding requisition line number to the current
11177: -- maximum shipment number. Due to this shipment numbers
11178: -- were getting skipped. Hence commented the following update
11179: -- statement and now updating the po_lines_interface in a loop using
11180: -- a cursor.
11181:
11182: OPEN interface_lines_temp;
11183: LOOP

Line 11191: UPDATE po_lines_interface pli

11187: EXIT WHEN interface_lines_temp%NOTFOUND;
11188:
11189: l_progress := '220';
11190:
11191: UPDATE po_lines_interface pli
11192: SET pli.shipment_num = x_shipment_num + x_count
11193: WHERE pli.requisition_line_id = x_requisition_line_id
11194: AND pli.interface_header_id = x_interface_header_id
11195: AND pli.line_num IS NOT NULL

Line 11228: FROM po_lines_interface pli

11224: -- Get maximum line number in interface table, to be used later
11225:
11226: SELECT NVL(max(pli.line_num), 0)
11227: INTO l_max_iface_line_num
11228: FROM po_lines_interface pli
11229: WHERE pli.interface_header_id = x_interface_header_id;
11230:
11231: --
11232:

Line 11287: UPDATE po_lines_interface pli

11283: -- to DEFAULT.
11284:
11285: -- Do not group; simply add 1 to each successive interface line
11286:
11287: UPDATE po_lines_interface pli
11288: SET pli.line_num = l_max_iface_line_num + 1
11289: WHERE pli.rowid = x_row_id
11290: AND pli.line_num IS NULL;
11291:

Line 11696: FROM po_lines_interface pli

11692: -- SQL Join: business logic for combining two lines
11693:
11694: SELECT min(pli.line_num)
11695: INTO x_po_line_num
11696: FROM po_lines_interface pli
11697: , po_requisition_lines_all prl
11698: , po_line_types_b PLT --
11699: WHERE pli.interface_header_id = x_interface_header_id
11700: AND pli.line_num is not null

Line 11855: FROM po_lines_interface pli

11851: END IF;
11852:
11853: SELECT MIN(pli.line_num)
11854: INTO x_po_line_num
11855: FROM po_lines_interface pli
11856: WHERE pli.interface_header_id = x_interface_header_id
11857: AND pli.line_num is not null
11858: AND pli.line_type_id = x_line_type_id
11859: AND nvl(pli.item_id, -1) = nvl(x_item_id, -1)

Line 11908: UPDATE po_lines_interface pli

11904:
11905: -- Since get_shipment_num will need it, we update the
11906: -- line number here.
11907:
11908: UPDATE po_lines_interface pli
11909: SET pli.line_num = x_po_line_num
11910: WHERE pli.interface_header_id = x_interface_header_id
11911: AND pli.requisition_line_id = x_requisition_line_id;
11912:

Line 11967: UPDATE po_lines_interface pli2

11963: --po_lines table as we are not supporting add to functionality.
11964:
11965: l_progress := '400';
11966:
11967: UPDATE po_lines_interface pli2
11968: SET (pli2.line_num, pli2.shipment_num) =
11969: (
11970: SELECT (NVL(max(pli.line_num), 0) + 1), 1
11971: FROM po_lines_interface pli

Line 11971: FROM po_lines_interface pli

11967: UPDATE po_lines_interface pli2
11968: SET (pli2.line_num, pli2.shipment_num) =
11969: (
11970: SELECT (NVL(max(pli.line_num), 0) + 1), 1
11971: FROM po_lines_interface pli
11972: WHERE pli.interface_header_id = x_interface_header_id
11973: )
11974: WHERE pli2.rowid = x_row_id;
11975:

Line 12010: p_message => 'Before select max line_num from po_lines_interface');

12006: l_progress:='420';
12007: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
12008: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
12009: p_token => l_progress,
12010: p_message => 'Before select max line_num from po_lines_interface');
12011: END IF;
12012:
12013: SELECT NVL(max(pli.line_num), 0)
12014: INTO x_int_line_num

Line 12015: FROM po_lines_interface pli

12011: END IF;
12012:
12013: SELECT NVL(max(pli.line_num), 0)
12014: INTO x_int_line_num
12015: FROM po_lines_interface pli
12016: WHERE pli.interface_header_id = x_interface_header_id;
12017:
12018: IF (x_line_num >= x_int_line_num) THEN
12019: x_line_num := x_line_num;

Line 12035: UPDATE po_lines_interface pli

12031: END IF;
12032:
12033: IF (x_requisition_line_id IS NOT NULL) THEN
12034:
12035: UPDATE po_lines_interface pli
12036: SET pli.line_num = x_line_num + 1,
12037: pli.shipment_num = 1
12038: WHERE pli.interface_header_id = x_interface_header_id
12039: AND pli.requisition_line_id = x_requisition_line_id;

Line 12045: UPDATE po_lines_interface pli

12041: ELSE
12042:
12043: -- no backing req line; use rowid
12044:
12045: UPDATE po_lines_interface pli
12046: SET pli.line_num = x_line_num + 1,
12047: pli.shipment_num = 1
12048: WHERE pli.rowid = x_row_id;
12049:

Line 12157: FROM po_lines_interface PLI

12153: SELECT min(line_num)
12154: , po_line_id
12155: INTO x_po_line_num
12156: , x_po_line_id
12157: FROM po_lines_interface PLI
12158: , po_line_types_b PLT --
12159: WHERE pli.interface_header_id = x_interface_header_id
12160: AND pli.line_num is not null
12161: AND pli.LINE_TYPE_ID = x_line_type_id

Line 12200: UPDATE po_lines_interface pli

12196: END;
12197:
12198: l_progress := '470';
12199:
12200: UPDATE po_lines_interface pli
12201: SET pli.line_num = x_po_line_num
12202: WHERE pli.interface_header_id = x_interface_header_id
12203: AND pli.requisition_line_id = x_requisition_line_id;
12204:

Line 12210: p_message => 'After update of po_lines_interface line_num');

12206:
12207: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
12208: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
12209: p_token => l_progress,
12210: p_message => 'After update of po_lines_interface line_num');
12211: END IF;
12212:
12213: ELSE
12214:

Line 12229: po_lines_interface pli

12225: SELECT pol.po_line_id
12226: INTO x_po_line_id
12227: FROM po_lines_all pol,
12228: po_headers_all poh,
12229: po_lines_interface pli
12230: WHERE pol.po_header_id = poh.po_header_id
12231: AND poh.segment1 = x_document_num
12232: AND NVL(poh.org_id, -99) = NVL(g_purchasing_ou_id, -99)
12233: AND poh.type_lookup_code = 'BLANKET' -- Bug# 1746943

Line 13021: FROM po_lines_interface pli,

13017: decode(psp.expense_accrual_code,'PERIOD END', 'N', 'Y')),
13018: 'INVENTORY', 'Y',
13019: 'SHOP FLOOR','Y')
13020: INTO x_receipt_required_flag
13021: FROM po_lines_interface pli,
13022: po_headers_interface phi,
13023: po_requisition_lines_all prl, --
13024: mtl_system_items msi,
13025: po_line_types plt,

Line 13084: FROM PO_LINES_INTERFACE PLI,

13080: SELECT PLI.shipment_num
13081: ,PLI.requisition_line_id
13082: INTO x_po_shipment_num
13083: ,x_req_line_to_check
13084: FROM PO_LINES_INTERFACE PLI,
13085: PO_REQUISITION_LINES_ALL PRL, --
13086: --bug 1942696 hr_location changes to reflect the new view
13087: MTL_SYSTEM_ITEMS MSI ,
13088: PO_LINE_TYPES PLT ,

Line 13206: FROM PO_LINES_INTERFACE PLI,

13202: to improve the performance
13203: */
13204: SELECT PLI.shipment_num
13205: INTO x_po_shipment_num
13206: FROM PO_LINES_INTERFACE PLI,
13207: PO_REQUISITION_LINES_ALL PRL, --
13208: MTL_SYSTEM_ITEMS MSI ,
13209: PO_LINE_TYPES PLT ,
13210: PO_SYSTEM_PARAMETERS_ALL PSP , --

Line 13333: FROM PO_LINES_INTERFACE PLI,

13329:
13330: l_progress:='190';
13331: SELECT PLI.shipment_num
13332: INTO x_po_shipment_num
13333: FROM PO_LINES_INTERFACE PLI,
13334: PO_REQUISITION_LINES_ALL PRL, --
13335: --bug 1942696 hr_location changes to reflect the new view
13336: MTL_SYSTEM_ITEMS MSI ,
13337: PO_LINE_TYPES PLT ,

Line 13509: update po_lines_interface

13505: */
13506:
13507: if x_requisition_line_id is not null then
13508: l_progress := '010';
13509: update po_lines_interface
13510: set shipment_num= x_po_shipment_num
13511: where interface_header_id=x_interface_header_id
13512: and requisition_line_id=x_requisition_line_id;
13513:

Line 13516: update po_lines_interface

13512: and requisition_line_id=x_requisition_line_id;
13513:
13514: else
13515: l_progress := '015';
13516: update po_lines_interface
13517: set shipment_num= x_po_shipment_num
13518: where interface_header_id=x_interface_header_id
13519: and rowid=x_row_id;
13520: end if;

Line 13566: from po_lines_interface pli

13562:
13563: l_progress := '040';
13564: select nvl(max(line_num),0)
13565: into x_int_line_num
13566: from po_lines_interface pli
13567: where pli.interface_header_id = x_interface_header_id;
13568:
13569: IF (x_line_num >= x_int_line_num) THEN
13570: x_line_num := x_line_num;

Line 13576: update po_lines_interface

13572: x_line_num := x_int_line_num;
13573: END IF;
13574:
13575: l_progress := '050';
13576: update po_lines_interface
13577: set line_num = x_line_num + 1
13578: where interface_header_id = x_interface_header_id
13579: and requisition_line_id = x_requisition_line_id;
13580: -- Bug 6072900

Line 13606: from po_lines_interface pli

13602: ** assigned in the interface table.
13603: */
13604: select nvl(max(shipment_num),0)
13605: into x_int_shipment_num
13606: from po_lines_interface pli
13607: where pli.interface_header_id = x_interface_header_id
13608: and pli.line_num = x_po_line_num;
13609:
13610: -- End of fix. Bug 605715, lpo, 01/05/98

Line 13640: from po_lines_interface pli

13636: ** assigned in the interface table.
13637: */
13638: select nvl(max(shipment_num),0)
13639: into x_int_shipment_num
13640: from po_lines_interface pli
13641: where pli.interface_header_id = x_interface_header_id;
13642:
13643: -- End of fix. Bug 605715, lpo, 01/05/98
13644:

Line 13657: update po_lines_interface

13653: END IF;
13654:
13655: if x_requisition_line_id is not null then
13656: l_progress := '110';
13657: update po_lines_interface
13658: set shipment_num = x_shipment_num + 1
13659: where interface_header_id=x_interface_header_id
13660: and requisition_line_id=x_requisition_line_id;
13661: else

Line 13663: update po_lines_interface

13659: where interface_header_id=x_interface_header_id
13660: and requisition_line_id=x_requisition_line_id;
13661: else
13662: l_progress := '120';
13663: update po_lines_interface
13664: set shipment_num = x_shipment_num + 1
13665: where interface_header_id=x_interface_header_id
13666: and rowid=x_row_id;
13667: end if;

Line 14125: records from po_lines_interface table to po_line_locations_all table

14121: /*============================================================================
14122: Name : CREATE_PRICE_BREAK
14123: Type : Private
14124: Function : This procedure is called from 'create_line'. This procedure inserts
14125: records from po_lines_interface table to po_line_locations_all table
14126: for the price break information.
14127: Pre-req : None
14128: Parameters:
14129: IN : p_po_line_id IN NUMBER REQUIRED

Line 14537: FROM po_lines_interface PLI, po_requisition_lines PRL

14533: END IF;
14534:
14535: SELECT count(*)
14536: INTO l_num_config_id_lines
14537: FROM po_lines_interface PLI, po_requisition_lines PRL
14538: WHERE PLI.interface_header_id = p_interface_header_id
14539: AND PLI.requisition_line_id = PRL.requisition_line_id -- JOIN
14540: AND PRL.supplier_ref_number IS NOT NULL;
14541:

Line 14888: -- p_interface_line_id: id of the line in po_lines_interface

14884: -- populated, use that information. Otherwise, create a default
14885: -- payitem. Also create DELIVERY and ADVANCE payitems as necessary.
14886: --Parameters:
14887: -- IN:
14888: -- p_interface_line_id: id of the line in po_lines_interface
14889: -- p_po_line_id: id of the line in po_lines_all
14890: -- p_precision: precision of the currency desired. Used to round amounts.
14891: -- p_ext_precision: extended precision of the currency desired.
14892: -- Used to round prices

Line 15621: -- p_interface_line_id: id of the line in po_lines_interface

15617: -- IN:
15618: -- p_req_line_id: id of the requisition line that is the source of
15619: -- the po line; null if no backing req.
15620: -- p_po_line_id: id of the line in po_lines_all
15621: -- p_interface_line_id: id of the line in po_lines_interface
15622: -- p_precision: precision of the currency desired. Used to round amounts.
15623: -- p_ext_precision: extended precision of the currency desired.
15624: -- Used to round prices
15625: -- OUT: