APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_COST_TXN_INTERFACE

Line 3735: from wip_cost_txn_interface wcti

3731: AND wt.operation_seq_num = l_job_op_seq_num
3732: and wt.resource_seq_num = l_res_seq_num
3733: )
3734: or exists ( select transaction_id
3735: from wip_cost_txn_interface wcti
3736: where wcti.wip_entity_id = p_wip_entity_id
3737: AND wcti.organization_id = p_org_id
3738: and wcti.operation_seq_num = l_job_op_seq_num
3739: and wcti.resource_seq_num = l_res_seq_num

Line 13027: from wip_cost_txn_interface

13023: is
13024:
13025: cursor c_lot_wcti_check is
13026: select 1
13027: from wip_cost_txn_interface
13028: where organization_id = p_org_id
13029: and wip_entity_id = p_wip_entity_id
13030: and operation_seq_num = p_op_seq_num
13031: and resource_seq_num = p_res_op_seq_num

Line 18509: from wip_cost_txn_interface

18505: begin
18506: l_stmt_num := 250.4;
18507: select 1
18508: into l_exists
18509: from wip_cost_txn_interface
18510: where wip_entity_id = p_wip_entity_id
18511: and transaction_type = 1
18512: and operation_seq_num = l_job_op_seq_num
18513: and organization_id = p_org_id;

Line 20947: from wip_cost_txn_interface

20943: where organization_id = p_organization_id
20944: and wip_entity_id = p_wip_entity_id)
20945: or exists (
20946: select 'x'
20947: from wip_cost_txn_interface
20948: where organization_id = p_organization_id
20949: and wip_entity_id = p_wip_entity_id)
20950: or exists (
20951: select 'x'

Line 21031: from wip_cost_txn_interface

21027: where organization_id = p_organization_id
21028: and wip_entity_id = p_wip_entity_id)
21029: or exists (
21030: select 'x'
21031: from wip_cost_txn_interface
21032: where organization_id = p_organization_id
21033: and wip_entity_id = p_wip_entity_id)
21034: or exists (
21035: select 'x'