DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on WIP_COST_TXN_INTERFACE

Line 3683: --resource txns in wip_cost_txn_interface table.

3679:
3680: BEGIN
3681: --Bug 3229281
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

Line 3707: from wip_cost_txn_interface

3703: and operation_seq_num = p_op_seq_num
3704: and transaction_type in (1,3)
3705: UNION ALL
3706: select resource_id,PRIMARY_QUANTITY
3707: from wip_cost_txn_interface
3708: where organization_id = p_organization_id
3709: and wip_entity_id = p_wip_entity_id
3710: and operation_seq_num = p_op_seq_num
3711: and transaction_type in (1,3)