DBA Data[Home] [Help]

APPS.WSM_WLT_VALIDATE_PVT dependencies on WSM_SM_STARTING_JOBS

Line 1173: wsm_sm_starting_jobs wst

1169:
1170: SELECT 1
1171: INTO l_later_txn_exists
1172: FROM wsm_split_merge_transactions wsmt,
1173: wsm_sm_starting_jobs wst
1174: WHERE wsmt.transaction_id = wst.transaction_id
1175: AND wst.wip_entity_id = p_sj_wip_entity_id
1176: AND wsmt.transaction_date > p_txn_date
1177: AND rownum = 1;

Line 7516: INSERT INTO wsm_sm_starting_jobs(

7512: while l_counter is not null loop
7513:
7514: l_starting_job_rec := p_wltx_starting_jobs_tbl(l_counter);
7515:
7516: INSERT INTO wsm_sm_starting_jobs(
7517: TRANSACTION_ID,
7518: WIP_ENTITY_ID,
7519: INTERNAL_GROUP_ID,
7520: PRIMARY_ITEM_ID,