DBA Data[Home] [Help]

APPS.WIP_OVERCOMPLETION dependencies on MTL_SYSTEM_ITEMS

Line 844: FROM mtl_system_items msi

840: SELECT
841: overcompletion_tolerance_type,
842: overcompletion_tolerance_value
843: INTO p_tolerance_type, p_tolerance_value
844: FROM mtl_system_items msi
845: WHERE
846: msi.inventory_item_id = p_primary_item_id
847: AND msi.organization_id = p_org_id;
848:

Line 1129: mtl_system_items msi

1125: p_oc_txn_id, /* overcompletion_transaction_id */
1126: NULL, /* overcompletion_transaction_qty */
1127: NULL /* overcompletion_primary_qty */
1128: from mtl_material_transactions_temp mmtt,
1129: mtl_system_items msi
1130: where
1131: mmtt.completion_transaction_id = p_parent_cpl_txn_id
1132: and mmtt.transaction_action_id = wip_constants.cplassy_action
1133: and mmtt.overcompletion_primary_qty IS NOT NULL