DBA Data[Home] [Help]

APPS.CSTPPIPV dependencies on MTL_TRANSACTIONS_INTERFACE

Line 492: -- create MTL_TRANSACTIONS_INTERFACE row for each POD,

488:
489: END LOOP; -- c_item_rec
490:
491: -------------------------------------------------------------------
492: -- create MTL_TRANSACTIONS_INTERFACE row for each POD,
493: -- with transaction_type = 80 (Average Cost Update)
494: -- If var_amount <> 0
495: -------------------------------------------------------------------
496: l_stmt_num := 55;

Line 498: INSERT INTO mtl_transactions_interface

494: -- If var_amount <> 0
495: -------------------------------------------------------------------
496: l_stmt_num := 55;
497:
498: INSERT INTO mtl_transactions_interface
499: (
500: transaction_interface_id,
501: source_code,
502: source_line_id, -- cavh.variance_header_id

Line 602: FROM mtl_transactions_interface mti

598: mti.organization_id,
599: 1, -- cost element id = 1
600: 1, -- this level = 1
601: mti.value_change
602: FROM mtl_transactions_interface mti
603: WHERE mti.source_header_id = l_batch_id
604: );
605:
606: IF (l_debug = 'Y') THEN