[Home] [Help]
1290: l_inv_org_location NUMBER;
1291: l_header_ship_to_location NUMBER;
1292: /* Bug 4969420 Starts here*/
1293: /* We use the blanket_price (from MCT) instead of the transaction_cost from MMT */
1294: /* This would be passed to the po_lines_interface */
1295: l_blanket_price NUMBER;
1296: /* Bug 4969420 Ends here */
1297:
1298: /* Bug 11900144. Addition of po_line_id */
1331: mtl_consumption_txn_temp
1332: WHERE batch_id = p_batch_id;
1333:
1334: -- Cursor to get the line info to insert into the
1335: -- po_lines_interface table for the corresponding header that is inserted.
1336:
1337: CURSOR line_csr_type IS
1338: SELECT
1339: inventory_item_id
1661: /* Bug 4969421 Starts here*/
1662: /*We use the blanket_price (from MCT) instead of the transaction_cost from MMT*/
1663: /*l_po_price was initially gettting the transaction cost from MMT.*/
1664: /*po_price now stores the blanket_price (PO currency) in MCT */
1665: /*l_blanket_price would be used to populate po_lines_interface. No conversions required */
1666: /*as blanket_price is in PO currency */
1667: l_blanket_price := l_po_price ;
1668: /* Bug 4969421 Ends here */
1669:
1946: , 9
1947: );
1948: END IF;
1949:
1950: SELECT PO_LINES_INTERFACE_S.NEXTVAL
1951: INTO l_interface_line_id
1952: FROM DUAL;
1953:
1954: /* Bug 7231720 If the Profile Option PO: Automatic Document Sourcing is set to "Yes" then
1960: /* Bug 11900144. Commented the below if condition as line details are taken from MCT,
1961: separate insert statements based on profile value are not required */
1962: --IF (nvl(fnd_profile.value('PO_AUTO_SOURCE_DOC'),'N') = 'Y') THEN
1963:
1964: INSERT INTO po_lines_interface
1965: ( interface_header_id
1966: , interface_line_id
1967: , line_num
1968: , line_type_id