DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on WSM_RESULTING_JOBS_INTERFACE

Line 4077: from wsm_resulting_jobs_interface wrji,

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

Line 5400: FROM WSM_RESULTING_JOBS_INTERFACE WRJI,

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

Line 5467: FROM WSM_RESULTING_JOBS_INTERFACE WRJI,

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