APPS.WSMPUTIL dependencies on WSM_LOT_MOVE_TXN_INTERFACE

Line 4088: from wsm_lot_move_txn_interface wlmti

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

Line 4095: from wsm_lot_move_txn_interface wlmti

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

Line 4676: FROM WSM_LOT_MOVE_TXN_INTERFACE WLMTI

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

Line 4700: FROM WSM_LOT_MOVE_TXN_INTERFACE WLMTI

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