DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on WIP_TRANSACTIONS

Line 3686: from wip_transactions

3682: --The following sql is commented out because it does not include
3683: --resource txns in wip_cost_txn_interface table.
3684: /* select wip_entity_id
3685: into l_dummy_number
3686: from wip_transactions
3687: where organization_id = p_organization_id
3688: and wip_entity_id = p_wip_entity_id
3689: and operation_seq_num = p_op_seq_num; */
3690:

Line 3700: from wip_transactions

3696: into l_dummy_number
3697: from
3698: (
3699: select resource_id,PRIMARY_QUANTITY
3700: from wip_transactions
3701: where organization_id = p_organization_id
3702: and wip_entity_id = p_wip_entity_id
3703: and operation_seq_num = p_op_seq_num
3704: and transaction_type in (1,3)