DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_TRANSACTIONS

Line 3728: from wip_transactions wt

3724: select 1
3725: into l_xst
3726: from dual
3727: where exists ( select transaction_id
3728: from wip_transactions wt
3729: where wt.wip_entity_id = p_wip_entity_id
3730: and wt.organization_id = p_org_id
3731: AND wt.operation_seq_num = l_job_op_seq_num
3732: and wt.resource_seq_num = l_res_seq_num

Line 13036: from wip_transactions

13032: and rownum = 1;
13033:
13034: cursor c_lot_wt_check is
13035: select 1
13036: from wip_transactions
13037: where organization_id = p_org_id
13038: and wip_entity_id = p_wip_entity_id
13039: and operation_seq_num = p_op_seq_num
13040: and resource_seq_num = p_res_op_seq_num