APPS.BOM_IMPLODER_PUB dependencies on BOM_COMPONENTS_B

Line 59: FROM bom_components_b

55: IS
56: COUNTER NUMBER;
57: BEGIN
58: SELECT COUNT(COMPONENT_SEQUENCE_ID) INTO COUNTER
59: FROM bom_components_b
60: WHERE pk1_value = PK_VALUE1
61: AND pk2_value = PK_VALUE2
62: AND to_date(impl_date, 'YYYY/MM/DD HH24:MI:SS')
63: between effectivity_date

Line 280: BOM_COMPONENTS_B BIC,

276: ) ) TO_END_ITEM_REVISION ,
277: BBM.EFFECTIVITY_CONTROL EFFECTIVITY_CONTROL
278: FROM
279: BOM_SMALL_IMPL_TEMP BITT,
280: BOM_COMPONENTS_B BIC,
281: BOM_STRUCTURES_B BBM
282: where
283: bitt.current_level = c_current_level
284: and bitt.organization_id = c_org_id

Line 564: from BOM_COMPONENTS_B bic2

560: or
561: (( c_implemented_only_option = 2
562: and bic.effectivity_date in /*bug 8304937,display both impl and unimpl BOM details */
563: (select effectivity_date /*bug 8304937,display both impl and unimpl BOM details */
564: from BOM_COMPONENTS_B bic2
565: where bic.bill_sequence_id = bic2.bill_sequence_id
566: and (
567: (nvl(bic.obj_name,G_EGO_OBJ_NAME) = G_EGO_OBJ_NAME
568: and (bic.component_item_id = bic2.component_item_id

Line 589: FROM BOM_COMPONENTS_B bic3

585: bic2.component_sequence_id,bic2.old_component_sequence_id)
586: , bic2.component_sequence_id)
587: and bic2.effectivity_date <= to_date(c_implosion_date,'YYYY/MM/DD HH24:MI:SS')
588: and NOT EXISTS (SELECT null
589: FROM BOM_COMPONENTS_B bic3
590: WHERE bic3.bill_sequence_id = bic.bill_sequence_id
591: AND bic3.old_component_sequence_id = bic.component_sequence_id
592: and NVL(BIC3.ECO_FOR_PRODUCTION,2)= 2
593: AND bic3.acd_type in (2,3)

Line 1148: AND brb.BILL_SEQUENCE_ID = (SELECT BILL_SEQUENCE_ID FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = bsit.COMPONENT_SEQUENCE_ID)

1144: )
1145: AND berd.ACD_TYPE = 1
1146: AND bsit.COMPONENT_PATH LIKE berd.EXCLUSION_PATH || '%'
1147: AND brb.RULE_ID = berd.RULE_ID
1148: AND brb.BILL_SEQUENCE_ID = (SELECT BILL_SEQUENCE_ID FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = bsit.COMPONENT_SEQUENCE_ID)
1149: AND bsit.COMPONENT_SEQUENCE_ID IS NOT NULL
1150: AND bsit.ROWID = bsit_source.ROWID
1151: )
1152: AND bsit_source.CURRENT_LEVEL > 0

Line 1708: SELECT 1 FROM BOM_COMPONENTS_B CPT1 WHERE CPT1.bill_sequence_id = BST1.bill_sequence_id

1704: AND BST1.ORGANIZATION_ID = org_id
1705: AND BST1.STRUCTURE_TYPE_ID = l_str_type_id
1706: AND exists
1707: (
1708: SELECT 1 FROM BOM_COMPONENTS_B CPT1 WHERE CPT1.bill_sequence_id = BST1.bill_sequence_id
1709: AND CPT1.Disable_date IS NULL
1710: )
1711: AND rownum = 1;
1712: exception when no_data_found then