APPS.BOM_COPY_ROUTING dependencies on FND_ATTACHED_DOCUMENTS

Line 128: fnd_attached_documents b

124:
125: SELECT COUNT (*)
126: INTO total_instructions
127: FROM bom_operation_sequences a,
128: fnd_attached_documents b
129: WHERE a.routing_sequence_id = from_rtg_seq_id
130: AND NVL (a.eco_for_production, 2) = 2
131: AND (display_option = 1
132: OR (display_option = 2

Line 153: fnd_attached_documents b

149:
150: SELECT COUNT (*)
151: INTO total_hdr_instructions
152: FROM bom_operational_routings a,
153: fnd_attached_documents b
154: WHERE a.routing_sequence_id = from_rtg_seq_id
155: AND a.routing_sequence_id = b.pk1_value
156: AND b.entity_name = 'BOM_OPERATIONAL_ROUTINGS';
157: --end bug fix 3473851

Line 1448: fnd_attached_documents2_pkg.copy_attachments

1444: BEGIN
1445: FOR x_op IN source_rtg
1446: LOOP
1447: sql_stmt_num := 201;
1448: fnd_attached_documents2_pkg.copy_attachments
1449: (x_from_entity_name => 'BOM_OPERATION_SEQUENCES',
1450: x_from_pk1_value => x_op.last_updated_by,
1451: x_from_pk2_value => '',
1452: x_from_pk3_value => '',

Line 1475: fnd_attached_documents2_pkg.copy_attachments

1471: END;
1472:
1473: --begin bug fix 3473851
1474: sql_stmt_num := 501;
1475: fnd_attached_documents2_pkg.copy_attachments
1476: (x_from_entity_name => 'BOM_OPERATIONAL_ROUTINGS',
1477: x_from_pk1_value => x_from_sequence_id,
1478: x_from_pk2_value => '',
1479: x_from_pk3_value => '',

Line 2013: FROM fnd_attached_documents b,

2009: sql_stmt_num := 39;
2010:
2011: SELECT COUNT (*)
2012: INTO copy_instrs
2013: FROM fnd_attached_documents b,
2014: bom_operation_sequences a
2015: WHERE a.routing_sequence_id = to_sequence_id
2016: AND a.operation_sequence_id = b.pk1_value
2017: AND b.entity_name = 'BOM_OPERATION_SEQUENCES';

Line 2024: FROM fnd_attached_documents b,

2020: sql_stmt_num := 40;
2021:
2022: SELECT COUNT (*)
2023: INTO copy_hdr_instrs
2024: FROM fnd_attached_documents b,
2025: bom_operational_routings a
2026: WHERE a.routing_sequence_id = to_sequence_id
2027: AND a.routing_sequence_id = b.pk1_value
2028: AND b.entity_name = 'BOM_OPERATIONAL_ROUTINGS';

Line 3913: FROM fnd_attached_documents b,

3909: sql_stmt_num := 39;
3910:
3911: SELECT COUNT (*)
3912: INTO copy_instrs
3913: FROM fnd_attached_documents b,
3914: bom_operation_sequences a
3915: WHERE a.routing_sequence_id = to_sequence_id
3916: AND a.operation_sequence_id = b.pk1_value
3917: AND b.entity_name = 'BOM_OPERATION_SEQUENCES';

Line 3924: FROM fnd_attached_documents b,

3920: sql_stmt_num := 40;
3921:
3922: SELECT COUNT (*)
3923: INTO copy_hdr_instrs
3924: FROM fnd_attached_documents b,
3925: bom_operational_routings a
3926: WHERE a.routing_sequence_id = to_sequence_id
3927: AND a.routing_sequence_id = b.pk1_value
3928: AND b.entity_name = 'BOM_OPERATIONAL_ROUTINGS';

Line 3978: fnd_attached_documents2_pkg.copy_attachments

3974:
3975: BEGIN
3976: FOR x_op IN source_rtg
3977: LOOP
3978: fnd_attached_documents2_pkg.copy_attachments
3979: (x_from_entity_name => 'BOM_OPERATION_SEQUENCES',
3980: x_from_pk1_value => x_op.last_updated_by,
3981: x_from_pk2_value => '',
3982: x_from_pk3_value => '',

Line 4002: fnd_attached_documents2_pkg.copy_attachments

3998:
3999: END;
4000:
4001: --begin bug fix 3473851
4002: fnd_attached_documents2_pkg.copy_attachments
4003: (x_from_entity_name => 'BOM_OPERATIONAL_ROUTINGS',
4004: x_from_pk1_value => p_from_sequence_id,
4005: x_from_pk2_value => '',
4006: x_from_pk3_value => '',