APPS.WSMPUTIL dependencies on WSM_LOT_MOVE_TXN_INTERFACE

Line 4086: from wsm_lot_move_txn_interface wlmti

4082: --Bug 4744794: Separate SQLs are used to select the records for the cases
4083: -- wip_entity_id is Null and wip_entity_id is NOT NULL
4084: or exists (
4085: select 1
4086: from wsm_lot_move_txn_interface wlmti
4087: --where (nvl(wlmti.wip_entity_id, -9999) = wt.wip_entity_id or
4088: -- nvl(wlmti.wip_entity_name, '@#$*') = wt.wip_entity_name)
4089: where wlmti.wip_entity_id = wt.wip_entity_id
4090: and wlmti.status in (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.RUNNING))

Line 4093: from wsm_lot_move_txn_interface wlmti

4089: where wlmti.wip_entity_id = wt.wip_entity_id
4090: and wlmti.status in (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.RUNNING))
4091: or exists (
4092: select 1
4093: from wsm_lot_move_txn_interface wlmti
4094: where wlmti.wip_entity_name = wt.wip_entity_name
4095: and wlmti.organization_id = wt.organization_id
4096: and wlmti.status in (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.RUNNING)));
4097:

Line 4679: FROM WSM_LOT_MOVE_TXN_INTERFACE WLMTI

4675: SELECT 1
4676: INTO l_rowcount
4677: From dual
4678: where exists (select 'Unprocessed WLMTI Record exists'
4679: FROM WSM_LOT_MOVE_TXN_INTERFACE WLMTI
4680: WHERE WLMTI.entity_type = 5
4681: AND WLMTI.wip_entity_id = p_wip_entity_id
4682: AND WLMTI.status IN (WIP_CONSTANTS.PENDING,
4683: WIP_CONSTANTS.RUNNING,

Line 4703: FROM WSM_LOT_MOVE_TXN_INTERFACE WLMTI

4699: SELECT 1
4700: INTO l_rowcount
4701: From dual
4702: where exists (select 'Unprocessed WLMTI Record exists'
4703: FROM WSM_LOT_MOVE_TXN_INTERFACE WLMTI
4704: WHERE WLMTI.entity_type = 5
4705: AND WLMTI.wip_entity_name = p_wip_entity_name
4706: AND WLMTI.organization_id = decode(p_organization_id, 0, WLMTI.organization_id, p_organization_id)
4707: AND WLMTI.status IN (WIP_CONSTANTS. PENDING,