APPS.WSMPJUPD dependencies on BOM_INVENTORY_COMPONENTS

Line 4060: from bom_inventory_components

4056: l_res_bill_seq_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wltx_resulting_jobs_tbl(l_rj_counter).wip_entity_id);
4057: --OPTII-PERF:Find if phantom exists or not.
4058: BEGIN
4059: select 1 into l_phantom_exists
4060: from bom_inventory_components
4061: where bill_sequence_id = p_wltx_resulting_jobs_tbl(l_rj_counter).common_bom_sequence_id
4062: and p_wltx_resulting_jobs_tbl(l_rj_counter).bom_revision_date between effectivity_date and
4063: nvl(disable_date,p_wltx_resulting_jobs_tbl(l_rj_counter).bom_revision_date+1)
4064: and wip_supply_type = 6

Line 4323: from bom_inventory_components

4319: l_res_bill_seq_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id);
4320: --OPTII-PERF
4321: BEGIN
4322: select 1 into l_phantom_exists
4323: from bom_inventory_components
4324: where bill_sequence_id = p_wltx_resulting_jobs_tbl(l_job_counter).common_bom_sequence_id
4325: and p_wltx_resulting_jobs_tbl(l_job_counter).bom_revision_date between effectivity_date and
4326: nvl(disable_date,p_wltx_resulting_jobs_tbl(l_job_counter).bom_revision_date+1)
4327: and wip_supply_type = 6

Line 4457: from bom_inventory_components

4453: l_res_bill_seq_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).wip_entity_id);
4454: --OPTII-PERF:Find l_phantom_exists
4455: BEGIN
4456: select 1 into l_phantom_exists
4457: from bom_inventory_components
4458: where bill_sequence_id = p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).common_bom_sequence_id
4459: and p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).bom_revision_date between effectivity_date and
4460: nvl(disable_date,p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).bom_revision_date+1)
4461: and wip_supply_type = 6