DBA Data[Home] [Help]

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 562: from BOM_COMPONENTS_B bic2

558: or
559: ( c_implemented_only_option = 2
560: and bic.effectivity_date =
561: (select max(effectivity_date)
562: from BOM_COMPONENTS_B bic2
563: where bic.bill_sequence_id = bic2.bill_sequence_id
564: and (
565: (nvl(bic.obj_name,G_EGO_OBJ_NAME) = G_EGO_OBJ_NAME
566: and (bic.component_item_id = bic2.component_item_id

Line 585: FROM BOM_COMPONENTS_B bic3

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

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

1136: )
1137: AND berd.ACD_TYPE = 1
1138: AND bsit.COMPONENT_PATH LIKE berd.EXCLUSION_PATH || '%'
1139: AND brb.RULE_ID = berd.RULE_ID
1140: AND brb.BILL_SEQUENCE_ID = (SELECT BILL_SEQUENCE_ID FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = bsit.COMPONENT_SEQUENCE_ID)
1141: AND bsit.COMPONENT_SEQUENCE_ID IS NOT NULL
1142: AND bsit.ROWID = bsit_source.ROWID
1143: )
1144: AND bsit_source.CURRENT_LEVEL > 0

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

1696: AND BST1.ORGANIZATION_ID = org_id
1697: AND BST1.STRUCTURE_TYPE_ID = l_str_type_id
1698: AND exists
1699: (
1700: SELECT 1 FROM BOM_COMPONENTS_B CPT1 WHERE CPT1.bill_sequence_id = BST1.bill_sequence_id
1701: AND CPT1.Disable_date IS NULL
1702: )
1703: AND rownum = 1;
1704: exception when no_data_found then