DBA Data[Home] [Help]

APPS.WIP_OVERCOMPLETION dependencies on MTL_SYSTEM_ITEMS

Line 850: FROM mtl_system_items msi

846: SELECT
847: overcompletion_tolerance_type,
848: overcompletion_tolerance_value
849: INTO p_tolerance_type, p_tolerance_value
850: FROM mtl_system_items msi
851: WHERE
852: msi.inventory_item_id = p_primary_item_id
853: AND msi.organization_id = p_org_id;
854:

Line 1135: mtl_system_items msi

1131: p_oc_txn_id, /* overcompletion_transaction_id */
1132: NULL, /* overcompletion_transaction_qty */
1133: NULL /* overcompletion_primary_qty */
1134: from mtl_material_transactions_temp mmtt,
1135: mtl_system_items msi
1136: where
1137: mmtt.completion_transaction_id = p_parent_cpl_txn_id
1138: and mmtt.transaction_action_id = wip_constants.cplassy_action
1139: and mmtt.overcompletion_primary_qty IS NOT NULL