DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on WSM_RESULTING_JOBS_INTERFACE

Line 4079: from wsm_resulting_jobs_interface wrji,

4075: and wsmti.header_id = wsji.header_id
4076: and wsmti.process_status in (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.RUNNING))
4077: or exists (
4078: select 1
4079: from wsm_resulting_jobs_interface wrji,
4080: wsm_split_merge_txn_interface wsmti
4081: where wrji.wip_entity_name = wt.wip_entity_name
4082: and wsmti.header_id = wrji.header_id
4083: and wsmti.process_status in (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.RUNNING))

Line 5397: FROM WSM_RESULTING_JOBS_INTERFACE WRJI,

5393: SELECT 1
5394: INTO l_rj_rowcount
5395: FROM dual
5396: WHERE exists (select 'Unprocessed WRJI/WSMTI Record exists'
5397: FROM WSM_RESULTING_JOBS_INTERFACE WRJI,
5398: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI
5399: WHERE WRJI.wip_entity_name = l_wip_entity_name
5400: AND WSMTI.organization_id = l_organization_id
5401: AND WSMTI.header_id = WRJI.header_id

Line 5464: FROM WSM_RESULTING_JOBS_INTERFACE WRJI,

5460: SELECT 1
5461: INTO l_rj_rowcount
5462: FROM dual
5463: WHERE exists (select 'Unprocessed WRJI/WSMTI Record exists'
5464: FROM WSM_RESULTING_JOBS_INTERFACE WRJI,
5465: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI
5466: WHERE WRJI.wip_entity_name = p_wip_entity_name
5467: AND WSMTI.organization_id = p_organization_id
5468: AND WSMTI.header_id = WRJI.header_id