[Home] [Help]
1495: l_inv_org_location NUMBER;
1496: l_header_ship_to_location NUMBER;
1497: /* Bug 4969420 Starts here*/
1498: /* We use the blanket_price (from MCT) instead of the transaction_cost from MMT */
1499: /* This would be passed to the po_lines_interface */
1500: l_blanket_price NUMBER;
1501: /* Bug 4969420 Ends here */
1502:
1503: /* bug 5373370 - Start */
1533: mtl_consumption_txn_temp
1534: WHERE batch_id = p_batch_id;
1535:
1536: -- Cursor to get the line info to insert into the
1537: -- po_lines_interface table for the corresponding header that is inserted.
1538:
1539: CURSOR line_csr_type IS
1540: SELECT
1541: inventory_item_id
1863: /* Bug 4969421 Starts here*/
1864: /*We use the blanket_price (from MCT) instead of the transaction_cost from MMT*/
1865: /*l_po_price was initially gettting the transaction cost from MMT.*/
1866: /*po_price now stores the blanket_price (PO currency) in MCT */
1867: /*l_blanket_price would be used to populate po_lines_interface. No conversions required */
1868: /*as blanket_price is in PO currency */
1869: l_blanket_price := l_po_price ;
1870: /* Bug 4969421 Ends here */
1871:
2147: , 9
2148: );
2149: END IF;
2150:
2151: SELECT PO_LINES_INTERFACE_S.NEXTVAL
2152: INTO l_interface_line_id
2153: FROM DUAL;
2154:
2155: /* Bug 7231720 If the Profile Option PO: Automatic Document Sourcing is set to "Yes" then
2159: from MMT.TRANSACTION_SOURCE_ID when the profile is set to "No" */
2160:
2161: IF (nvl(fnd_profile.value('PO_AUTO_SOURCE_DOC'),'N') = 'Y') THEN
2162:
2163: INSERT INTO po_lines_interface
2164: ( interface_header_id
2165: , interface_line_id
2166: , line_num
2167: , line_type_id
2224: and ROWNUM = 1;
2225:
2226: ELSE /* Profile Option PO: Automatic Document Sourcing is set to "No" */
2227:
2228: INSERT INTO po_lines_interface
2229: ( interface_header_id
2230: , interface_line_id
2231: , line_num
2232: , line_type_id