DBA Data[Home] [Help]

APPS.WIP_FLOW_UTILITIES dependencies on MTL_SYSTEM_ITEMS_KFV

Line 2331: mtl_system_items_kfv msi

2327: mti.transfer_cost_group_id cost_group_id,
2328: least( 1, NVL(mti.transfer_lpn_id, 0) + NVL(mti.content_lpn_id, 0) ) containerized,
2329: mti.transaction_header_id -- bugfix 4455722
2330: from mtl_transactions_interface mti,
2331: mtl_system_items_kfv msi
2332: where mti.parent_id = txn_interface_id
2333: and nvl(mti.operation_seq_num, 1) > 0 /* not for phatom assembly */
2334: and mti.transaction_action_id in (1,27,33,34) /*wip_constants.isscomp_action, wip_constants.retcomp_action, wip_constants.issnegc_action, wip_constants.retnegc_action)*/
2335: and mti.inventory_item_id = msi.inventory_item_id