DBA Data[Home] [Help]

APPS.BOM_COPY_BILL dependencies on BOM_REFERENCE_DESIGNATORS

Line 122: FROM bom_reference_designators brd,

118: sql_stmt_num := 3;
119:
120: SELECT COUNT (*)
121: INTO total_reference_designators
122: FROM bom_reference_designators brd,
123: bom_inventory_components bic
124: WHERE bic.bill_sequence_id = from_bill_seq_id
125: AND NVL (bic.eco_for_production, 2) = 2
126: AND bic.component_sequence_id = brd.component_sequence_id

Line 5477: INSERT INTO bom_reference_designators

5473: sql_stmt_num := 46;
5474:
5475: IF specific_copy_flag = 'Y'
5476: THEN
5477: INSERT INTO bom_reference_designators
5478: (component_reference_designator,
5479: last_update_date,
5480: last_updated_by,
5481: creation_date,

Line 5539: FROM bom_reference_designators brd,

5535: brd.attribute12,
5536: brd.attribute13,
5537: brd.attribute14,
5538: brd.attribute15
5539: FROM bom_reference_designators brd,
5540: bom_components_b bic,
5541: bom_copy_explosions_v bev
5542: WHERE bic.bill_sequence_id = to_sequence_id
5543: AND NVL (bic.eco_for_production, 2) = 2

Line 5554: INSERT INTO bom_reference_designators

5550: OR (specific_copy_flag = 'Y'
5551: AND copy_all_rfds_flag = 'Y')
5552: )
5553: THEN
5554: INSERT INTO bom_reference_designators
5555: (component_reference_designator,
5556: last_update_date,
5557: last_updated_by,
5558: creation_date,

Line 5616: FROM bom_reference_designators brd,

5612: brd.attribute12,
5613: brd.attribute13,
5614: brd.attribute14,
5615: brd.attribute15
5616: FROM bom_reference_designators brd,
5617: bom_inventory_components bic
5618: WHERE bic.bill_sequence_id = to_sequence_id
5619: AND NVL (bic.eco_for_production, 2) = 2
5620: AND brd.component_sequence_id = bic.created_by

Line 11118: INSERT INTO bom_reference_designators

11114: --Turn on trigger BOMTBICX
11115: bom_globals.g_skip_bomtbicx := 'N';
11116: sql_stmt_num := 46;
11117:
11118: INSERT INTO bom_reference_designators
11119: (component_reference_designator,
11120: last_update_date,
11121: last_updated_by,
11122: creation_date,

Line 11180: FROM bom_reference_designators brd,

11176: brd.attribute12,
11177: brd.attribute13,
11178: brd.attribute14,
11179: brd.attribute15
11180: FROM bom_reference_designators brd,
11181: bom_components_b bic,
11182: bom_copy_explosions_v bev
11183: WHERE bic.bill_sequence_id = to_sequence_id
11184: AND NVL (bic.eco_for_production, 2) = 2