DBA Data[Home] [Help]

APPS.BOM_COMPUTE_FUNCTIONS dependencies on BOM_STRUCTURES_B

Line 78: ,bom_structures_b parent

74: IS
75: CURSOR c_parent_or_leaf IS
76: SELECT 'Parent'
77: FROM bom_components_b comp
78: ,bom_structures_b parent
79: WHERE comp.component_sequence_id = p_component_sequence_id
80: AND comp.bill_sequence_id = parent.bill_sequence_id
81: AND EXISTS (SELECT bill_sequence_id
82: FROM bom_structures_b comp_struct

Line 82: FROM bom_structures_b comp_struct

78: ,bom_structures_b parent
79: WHERE comp.component_sequence_id = p_component_sequence_id
80: AND comp.bill_sequence_id = parent.bill_sequence_id
81: AND EXISTS (SELECT bill_sequence_id
82: FROM bom_structures_b comp_struct
83: WHERE comp_struct.pk1_value = comp.pk1_value
84: AND nvl(comp_struct.pk2_value, 'xxxxxxxxxxxxxxx') = nvl(comp.pk2_value,'xxxxxxxxxxxxxxx')
85: AND comp_struct.obj_name = comp.obj_name
86: AND comp_struct.alternate_bom_designator = parent.alternate_bom_designator