APPS.WSMPJUPD dependencies on BOM_INVENTORY_COMPONENTS

Line 4054: from bom_inventory_components

4050: l_res_bill_seq_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wltx_resulting_jobs_tbl(l_rj_counter).wip_entity_id);
4051: --OPTII-PERF:Find if phantom exists or not.
4052: BEGIN
4053: select 1 into l_phantom_exists
4054: from bom_inventory_components
4055: where bill_sequence_id = p_wltx_resulting_jobs_tbl(l_rj_counter).common_bom_sequence_id
4056: and p_wltx_resulting_jobs_tbl(l_rj_counter).bom_revision_date between effectivity_date and
4057: nvl(disable_date,p_wltx_resulting_jobs_tbl(l_rj_counter).bom_revision_date+1)
4058: and wip_supply_type = 6

Line 4315: from bom_inventory_components

4311: l_res_bill_seq_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id);
4312: --OPTII-PERF
4313: BEGIN
4314: select 1 into l_phantom_exists
4315: from bom_inventory_components
4316: where bill_sequence_id = p_wltx_resulting_jobs_tbl(l_job_counter).common_bom_sequence_id
4317: and p_wltx_resulting_jobs_tbl(l_job_counter).bom_revision_date between effectivity_date and
4318: nvl(disable_date,p_wltx_resulting_jobs_tbl(l_job_counter).bom_revision_date+1)
4319: and wip_supply_type = 6

Line 4449: from bom_inventory_components

4445: l_res_bill_seq_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).wip_entity_id);
4446: --OPTII-PERF:Find l_phantom_exists
4447: BEGIN
4448: select 1 into l_phantom_exists
4449: from bom_inventory_components
4450: where bill_sequence_id = p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).common_bom_sequence_id
4451: and p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).bom_revision_date between effectivity_date and
4452: nvl(disable_date,p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).bom_revision_date+1)
4453: and wip_supply_type = 6