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 1396: fnd_attached_documents2_pkg.copy_attachments

1392: BEGIN
1393: FOR x_op IN source_rtg
1394: LOOP
1395: sql_stmt_num := 201;
1396: fnd_attached_documents2_pkg.copy_attachments
1397: (x_from_entity_name => 'BOM_OPERATION_SEQUENCES',
1398: x_from_pk1_value => x_op.last_updated_by,
1399: x_from_pk2_value => '',
1400: x_from_pk3_value => '',

Line 1423: fnd_attached_documents2_pkg.copy_attachments

1419: END;
1420:
1421: --begin bug fix 3473851
1422: sql_stmt_num := 501;
1423: fnd_attached_documents2_pkg.copy_attachments
1424: (x_from_entity_name => 'BOM_OPERATIONAL_ROUTINGS',
1425: x_from_pk1_value => x_from_sequence_id,
1426: x_from_pk2_value => '',
1427: x_from_pk3_value => '',

Line 1949: FROM fnd_attached_documents b,

1945: sql_stmt_num := 39;
1946:
1947: SELECT COUNT (*)
1948: INTO copy_instrs
1949: FROM fnd_attached_documents b,
1950: bom_operation_sequences a
1951: WHERE a.routing_sequence_id = to_sequence_id
1952: AND a.operation_sequence_id = b.pk1_value
1953: AND b.entity_name = 'BOM_OPERATION_SEQUENCES';

Line 1960: FROM fnd_attached_documents b,

1956: sql_stmt_num := 40;
1957:
1958: SELECT COUNT (*)
1959: INTO copy_hdr_instrs
1960: FROM fnd_attached_documents b,
1961: bom_operational_routings a
1962: WHERE a.routing_sequence_id = to_sequence_id
1963: AND a.routing_sequence_id = b.pk1_value
1964: AND b.entity_name = 'BOM_OPERATIONAL_ROUTINGS';

Line 3783: FROM fnd_attached_documents b,

3779: sql_stmt_num := 39;
3780:
3781: SELECT COUNT (*)
3782: INTO copy_instrs
3783: FROM fnd_attached_documents b,
3784: bom_operation_sequences a
3785: WHERE a.routing_sequence_id = to_sequence_id
3786: AND a.operation_sequence_id = b.pk1_value
3787: AND b.entity_name = 'BOM_OPERATION_SEQUENCES';

Line 3794: FROM fnd_attached_documents b,

3790: sql_stmt_num := 40;
3791:
3792: SELECT COUNT (*)
3793: INTO copy_hdr_instrs
3794: FROM fnd_attached_documents b,
3795: bom_operational_routings a
3796: WHERE a.routing_sequence_id = to_sequence_id
3797: AND a.routing_sequence_id = b.pk1_value
3798: AND b.entity_name = 'BOM_OPERATIONAL_ROUTINGS';

Line 3848: fnd_attached_documents2_pkg.copy_attachments

3844:
3845: BEGIN
3846: FOR x_op IN source_rtg
3847: LOOP
3848: fnd_attached_documents2_pkg.copy_attachments
3849: (x_from_entity_name => 'BOM_OPERATION_SEQUENCES',
3850: x_from_pk1_value => x_op.last_updated_by,
3851: x_from_pk2_value => '',
3852: x_from_pk3_value => '',

Line 3872: fnd_attached_documents2_pkg.copy_attachments

3868:
3869: END;
3870:
3871: --begin bug fix 3473851
3872: fnd_attached_documents2_pkg.copy_attachments
3873: (x_from_entity_name => 'BOM_OPERATIONAL_ROUTINGS',
3874: x_from_pk1_value => p_from_sequence_id,
3875: x_from_pk2_value => '',
3876: x_from_pk3_value => '',