DBA Data[Home] [Help]

APPS.JAI_RCV_OPM_COSTING_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 80: AND EXISTS ( Select 1 from MTL_SYSTEM_ITEMS_B msib where msib.inventory_item_id = jrt.inventory_item_id

76: WHERE jrt.shipment_header_id = rsl.shipment_header_id
77: AND jrt.shipment_line_id = rsl.shipment_line_id
78: AND jrt.transaction_type = lv_deliver_trx
79: AND trunc(jrt.transaction_date) between cp_start_date and cp_end_date /*bug 8830292*/
80: AND EXISTS ( Select 1 from MTL_SYSTEM_ITEMS_B msib where msib.inventory_item_id = jrt.inventory_item_id
81: and msib.process_costing_enabled_flag ='Y') --Added by nprashar for bug # 10272657
82: );
83:
84: /*cursor modified for bug 8505362, to include the quanity in primary UOM*/