DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_TRANSACTIONS

Line 3723: from wip_transactions wt

3719: select 1
3720: into l_xst
3721: from dual
3722: where exists ( select transaction_id
3723: from wip_transactions wt
3724: where wt.wip_entity_id = p_wip_entity_id
3725: and wt.organization_id = p_org_id
3726: AND wt.operation_seq_num = l_job_op_seq_num
3727: and wt.resource_seq_num = l_res_seq_num

Line 12932: from wip_transactions

12928: and rownum = 1;
12929:
12930: cursor c_lot_wt_check is
12931: select 1
12932: from wip_transactions
12933: where organization_id = p_org_id
12934: and wip_entity_id = p_wip_entity_id
12935: and operation_seq_num = p_op_seq_num
12936: and resource_seq_num = p_res_op_seq_num