eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_COPY_ROUTING dependencies on BOM_OPERATIONAL_ROUTINGS

Line 152: FROM bom_operational_routings a,

148: sql_stmt_num := 5;
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';

Line 156: AND b.entity_name = 'BOM_OPERATIONAL_ROUTINGS';

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
158: EXCEPTION
159: WHEN OTHERS
160: THEN

Line 315: FROM bom_operational_routings

311: sql_stmt_num := 10;
312:
313: SELECT common_routing_sequence_id
314: INTO x_from_sequence_id
315: FROM bom_operational_routings
316: WHERE routing_sequence_id = from_sequence_id;
317:
318: IF (from_org_id <> to_org_id)
319: THEN

Line 640: bom_operational_routings bor

636: -- There should not be any no data found for this case
637: SELECT
638: assembly_item_id INTO l_from_item_id
639: FROM
640: bom_operational_routings bor
641: WHERE
642: bor.routing_sequence_id = from_sequence_id;
643: INSERT INTO mtl_interface_errors
644: (unique_id,

Line 1476: (x_from_entity_name => 'BOM_OPERATIONAL_ROUTINGS',

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 => '',
1480: x_from_pk4_value => '',

Line 1482: x_to_entity_name => 'BOM_OPERATIONAL_ROUTINGS',

1478: x_from_pk2_value => '',
1479: x_from_pk3_value => '',
1480: x_from_pk4_value => '',
1481: x_from_pk5_value => '',
1482: x_to_entity_name => 'BOM_OPERATIONAL_ROUTINGS',
1483: x_to_pk1_value => to_sequence_id,
1484: x_to_pk2_value => '',
1485: x_to_pk3_value => '',
1486: x_to_pk4_value => '',

Line 2025: bom_operational_routings a

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';
2029:

Line 2028: AND b.entity_name = 'BOM_OPERATIONAL_ROUTINGS';

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';
2029:
2030: --end bug fix 3473851
2031: IF (from_org_id = to_org_id)
2032: THEN

Line 2070: UPDATE bom_operational_routings

2066: p_alt_desg_for_prim_rtg IN VARCHAR2
2067: )
2068: IS
2069: BEGIN
2070: UPDATE bom_operational_routings
2071: SET alternate_routing_designator = 'NONE'
2072: WHERE organization_id = p_org_id
2073: AND assembly_item_id = p_ass_itm_id
2074: AND alternate_routing_designator = p_alt_rtg_desg;

Line 2076: UPDATE bom_operational_routings

2072: WHERE organization_id = p_org_id
2073: AND assembly_item_id = p_ass_itm_id
2074: AND alternate_routing_designator = p_alt_rtg_desg;
2075:
2076: UPDATE bom_operational_routings
2077: SET alternate_routing_designator = p_alt_desg_for_prim_rtg
2078: WHERE organization_id = p_org_id
2079: AND assembly_item_id = p_ass_itm_id
2080: AND NVL (alternate_routing_designator, 'NULL') = 'NULL';

Line 2082: UPDATE bom_operational_routings

2078: WHERE organization_id = p_org_id
2079: AND assembly_item_id = p_ass_itm_id
2080: AND NVL (alternate_routing_designator, 'NULL') = 'NULL';
2081:
2082: UPDATE bom_operational_routings
2083: SET alternate_routing_designator = NULL
2084: WHERE organization_id = p_org_id
2085: AND assembly_item_id = p_ass_itm_id
2086: AND alternate_routing_designator = 'NONE';

Line 2156: --bom_operational_routings bor

2152: AND alternate_routing_designator = p_alt_rtg_desg)
2153: OR EXISTS (
2154: SELECT 1 /* Check for WIP Jobs on primary */
2155: FROM wip_discrete_jobs job --modified for bug 10431513
2156: --bom_operational_routings bor
2157: WHERE job.organization_id = p_org_id
2158: AND job.primary_item_id = p_ass_itm_id
2159: AND job.alternate_routing_designator IS NULL)
2160: OR EXISTS (

Line 2163: --bom_operational_routings bor

2159: AND job.alternate_routing_designator IS NULL)
2160: OR EXISTS (
2161: SELECT 1 /* Check for WIP Jobs on alternate */
2162: FROM wip_discrete_jobs job --modified for bug 10431513
2163: --bom_operational_routings bor
2164: WHERE job.organization_id = p_org_id
2165: AND job.primary_item_id = p_ass_itm_id
2166: AND job.alternate_routing_designator = p_alt_rtg_desg);
2167: BEGIN

Line 2243: UPDATE bom_operational_routings

2239: )
2240: IS
2241: BEGIN
2242:
2243: UPDATE bom_operational_routings
2244: SET common_assembly_item_id =
2245: ( SELECT assembly_item_id
2246: FROM bom_operational_routings
2247: WHERE assembly_item_id = p_ass_itm_id

Line 2246: FROM bom_operational_routings

2242:
2243: UPDATE bom_operational_routings
2244: SET common_assembly_item_id =
2245: ( SELECT assembly_item_id
2246: FROM bom_operational_routings
2247: WHERE assembly_item_id = p_ass_itm_id
2248: AND organization_id = p_org_id
2249: AND alternate_routing_designator = p_alt_rtg_desg )
2250: , common_routing_sequence_id =

Line 2252: FROM bom_operational_routings

2248: AND organization_id = p_org_id
2249: AND alternate_routing_designator = p_alt_rtg_desg )
2250: , common_routing_sequence_id =
2251: ( SELECT routing_sequence_id
2252: FROM bom_operational_routings
2253: WHERE assembly_item_id = p_ass_itm_id
2254: AND organization_id = p_org_id
2255: AND alternate_routing_designator = p_alt_rtg_desg )
2256: , completion_subinventory =

Line 2258: FROM bom_operational_routings

2254: AND organization_id = p_org_id
2255: AND alternate_routing_designator = p_alt_rtg_desg )
2256: , completion_subinventory =
2257: ( SELECT completion_subinventory
2258: FROM bom_operational_routings
2259: WHERE assembly_item_id = p_ass_itm_id
2260: AND organization_id = p_org_id
2261: AND alternate_routing_designator = p_alt_rtg_desg )
2262: , completion_locator_id =

Line 2264: FROM bom_operational_routings

2260: AND organization_id = p_org_id
2261: AND alternate_routing_designator = p_alt_rtg_desg )
2262: , completion_locator_id =
2263: ( SELECT completion_locator_id
2264: FROM bom_operational_routings
2265: WHERE assembly_item_id = p_ass_itm_id
2266: AND organization_id = p_org_id
2267: AND alternate_routing_designator = p_alt_rtg_desg )
2268: WHERE common_routing_sequence_id IN

Line 2269: ( SELECT routing_Sequence_id FROM bom_operational_routings

2265: WHERE assembly_item_id = p_ass_itm_id
2266: AND organization_id = p_org_id
2267: AND alternate_routing_designator = p_alt_rtg_desg )
2268: WHERE common_routing_sequence_id IN
2269: ( SELECT routing_Sequence_id FROM bom_operational_routings
2270: WHERE assembly_item_id = p_ass_itm_id
2271: AND organization_id = p_org_id
2272: AND alternate_routing_designator IS NULL )
2273: AND common_assembly_item_id IN

Line 2274: ( SELECT assembly_item_id FROM bom_operational_routings

2270: WHERE assembly_item_id = p_ass_itm_id
2271: AND organization_id = p_org_id
2272: AND alternate_routing_designator IS NULL )
2273: AND common_assembly_item_id IN
2274: ( SELECT assembly_item_id FROM bom_operational_routings
2275: WHERE assembly_item_id = p_ass_itm_id
2276: AND organization_id = p_org_id
2277: AND alternate_routing_designator IS NULL );
2278:

Line 2290: UPDATE bom_operational_routings

2286: )
2287: IS
2288: BEGIN
2289:
2290: UPDATE bom_operational_routings
2291: SET common_assembly_item_id =
2292: ( SELECT assembly_item_id
2293: FROM bom_operational_routings
2294: WHERE assembly_item_id = p_ass_itm_id

Line 2293: FROM bom_operational_routings

2289:
2290: UPDATE bom_operational_routings
2291: SET common_assembly_item_id =
2292: ( SELECT assembly_item_id
2293: FROM bom_operational_routings
2294: WHERE assembly_item_id = p_ass_itm_id
2295: AND organization_id = p_org_id
2296: AND alternate_routing_designator IS NULL )
2297: , common_routing_sequence_id =

Line 2299: FROM bom_operational_routings

2295: AND organization_id = p_org_id
2296: AND alternate_routing_designator IS NULL )
2297: , common_routing_sequence_id =
2298: ( SELECT routing_sequence_id
2299: FROM bom_operational_routings
2300: WHERE assembly_item_id = p_ass_itm_id
2301: AND organization_id = p_org_id
2302: AND alternate_routing_designator IS NULL )
2303: , completion_subinventory =

Line 2305: FROM bom_operational_routings

2301: AND organization_id = p_org_id
2302: AND alternate_routing_designator IS NULL )
2303: , completion_subinventory =
2304: ( SELECT completion_subinventory
2305: FROM bom_operational_routings
2306: WHERE assembly_item_id = p_ass_itm_id
2307: AND organization_id = p_org_id
2308: AND alternate_routing_designator IS NULL )
2309: , completion_locator_id =

Line 2311: FROM bom_operational_routings

2307: AND organization_id = p_org_id
2308: AND alternate_routing_designator IS NULL )
2309: , completion_locator_id =
2310: ( SELECT completion_locator_id
2311: FROM bom_operational_routings
2312: WHERE assembly_item_id = p_ass_itm_id
2313: AND organization_id = p_org_id
2314: AND alternate_routing_designator IS NULL )
2315: , alternate_routing_designator =

Line 2429: FROM bom_operational_routings

2425: sql_stmt_num := 10;
2426:
2427: SELECT common_routing_sequence_id
2428: INTO x_from_sequence_id
2429: FROM bom_operational_routings
2430: WHERE routing_sequence_id = from_sequence_id;
2431:
2432: IF (from_org_id <> to_org_id)
2433: THEN

Line 2664: bom_operational_routings bor

2660: -- There should not be any no data found for this case
2661: SELECT
2662: assembly_item_id INTO l_from_item_id
2663: FROM
2664: bom_operational_routings bor
2665: WHERE
2666: bor.routing_sequence_id = from_sequence_id;
2667: INSERT INTO mtl_interface_errors
2668: (unique_id,

Line 3925: bom_operational_routings a

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';
3929:

Line 3928: AND b.entity_name = 'BOM_OPERATIONAL_ROUTINGS';

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';
3929:
3930: --end bug fix 3473851
3931: IF (from_org_id = to_org_id)
3932: THEN

Line 4003: (x_from_entity_name => 'BOM_OPERATIONAL_ROUTINGS',

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 => '',
4007: x_from_pk4_value => '',

Line 4009: x_to_entity_name => 'BOM_OPERATIONAL_ROUTINGS',

4005: x_from_pk2_value => '',
4006: x_from_pk3_value => '',
4007: x_from_pk4_value => '',
4008: x_from_pk5_value => '',
4009: x_to_entity_name => 'BOM_OPERATIONAL_ROUTINGS',
4010: x_to_pk1_value => p_to_sequence_id,
4011: x_to_pk2_value => '',
4012: x_to_pk3_value => '',
4013: x_to_pk4_value => '',