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 633: bom_operational_routings bor

629: -- There should not be any no data found for this case
630: SELECT
631: assembly_item_id INTO l_from_item_id
632: FROM
633: bom_operational_routings bor
634: WHERE
635: bor.routing_sequence_id = from_sequence_id;
636: INSERT INTO mtl_interface_errors
637: (unique_id,

Line 1424: (x_from_entity_name => 'BOM_OPERATIONAL_ROUTINGS',

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

Line 1430: x_to_entity_name => 'BOM_OPERATIONAL_ROUTINGS',

1426: x_from_pk2_value => '',
1427: x_from_pk3_value => '',
1428: x_from_pk4_value => '',
1429: x_from_pk5_value => '',
1430: x_to_entity_name => 'BOM_OPERATIONAL_ROUTINGS',
1431: x_to_pk1_value => to_sequence_id,
1432: x_to_pk2_value => '',
1433: x_to_pk3_value => '',
1434: x_to_pk4_value => '',

Line 1961: bom_operational_routings a

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

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

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';
1965:
1966: --end bug fix 3473851
1967: IF (from_org_id = to_org_id)
1968: THEN

Line 2006: UPDATE bom_operational_routings

2002: p_alt_desg_for_prim_rtg IN VARCHAR2
2003: )
2004: IS
2005: BEGIN
2006: UPDATE bom_operational_routings
2007: SET alternate_routing_designator = 'NONE'
2008: WHERE organization_id = p_org_id
2009: AND assembly_item_id = p_ass_itm_id
2010: AND alternate_routing_designator = p_alt_rtg_desg;

Line 2012: UPDATE bom_operational_routings

2008: WHERE organization_id = p_org_id
2009: AND assembly_item_id = p_ass_itm_id
2010: AND alternate_routing_designator = p_alt_rtg_desg;
2011:
2012: UPDATE bom_operational_routings
2013: SET alternate_routing_designator = p_alt_desg_for_prim_rtg
2014: WHERE organization_id = p_org_id
2015: AND assembly_item_id = p_ass_itm_id
2016: AND NVL (alternate_routing_designator, 'NULL') = 'NULL';

Line 2018: UPDATE bom_operational_routings

2014: WHERE organization_id = p_org_id
2015: AND assembly_item_id = p_ass_itm_id
2016: AND NVL (alternate_routing_designator, 'NULL') = 'NULL';
2017:
2018: UPDATE bom_operational_routings
2019: SET alternate_routing_designator = NULL
2020: WHERE organization_id = p_org_id
2021: AND assembly_item_id = p_ass_itm_id
2022: AND alternate_routing_designator = 'NONE';

Line 2092: bom_operational_routings bor

2088: AND alternate_routing_designator = p_alt_rtg_desg)
2089: OR EXISTS (
2090: SELECT 1 /* Check for WIP Jobs on primary */
2091: FROM wip_discrete_jobs job,
2092: bom_operational_routings bor
2093: WHERE job.organization_id = p_org_id
2094: AND job.primary_item_id = p_ass_itm_id
2095: AND job.alternate_routing_designator IS NULL)
2096: OR EXISTS (

Line 2099: bom_operational_routings bor

2095: AND job.alternate_routing_designator IS NULL)
2096: OR EXISTS (
2097: SELECT 1 /* Check for WIP Jobs on alternate */
2098: FROM wip_discrete_jobs job,
2099: bom_operational_routings bor
2100: WHERE job.organization_id = p_org_id
2101: AND job.primary_item_id = p_ass_itm_id
2102: AND job.alternate_routing_designator = p_alt_rtg_desg);
2103: BEGIN

Line 2179: UPDATE bom_operational_routings

2175: )
2176: IS
2177: BEGIN
2178:
2179: UPDATE bom_operational_routings
2180: SET common_assembly_item_id =
2181: ( SELECT assembly_item_id
2182: FROM bom_operational_routings
2183: WHERE assembly_item_id = p_ass_itm_id

Line 2182: FROM bom_operational_routings

2178:
2179: UPDATE bom_operational_routings
2180: SET common_assembly_item_id =
2181: ( SELECT assembly_item_id
2182: FROM bom_operational_routings
2183: WHERE assembly_item_id = p_ass_itm_id
2184: AND organization_id = p_org_id
2185: AND alternate_routing_designator = p_alt_rtg_desg )
2186: , common_routing_sequence_id =

Line 2188: FROM bom_operational_routings

2184: AND organization_id = p_org_id
2185: AND alternate_routing_designator = p_alt_rtg_desg )
2186: , common_routing_sequence_id =
2187: ( SELECT routing_sequence_id
2188: FROM bom_operational_routings
2189: WHERE assembly_item_id = p_ass_itm_id
2190: AND organization_id = p_org_id
2191: AND alternate_routing_designator = p_alt_rtg_desg )
2192: , completion_subinventory =

Line 2194: FROM bom_operational_routings

2190: AND organization_id = p_org_id
2191: AND alternate_routing_designator = p_alt_rtg_desg )
2192: , completion_subinventory =
2193: ( SELECT completion_subinventory
2194: FROM bom_operational_routings
2195: WHERE assembly_item_id = p_ass_itm_id
2196: AND organization_id = p_org_id
2197: AND alternate_routing_designator = p_alt_rtg_desg )
2198: , completion_locator_id =

Line 2200: FROM bom_operational_routings

2196: AND organization_id = p_org_id
2197: AND alternate_routing_designator = p_alt_rtg_desg )
2198: , completion_locator_id =
2199: ( SELECT completion_locator_id
2200: FROM bom_operational_routings
2201: WHERE assembly_item_id = p_ass_itm_id
2202: AND organization_id = p_org_id
2203: AND alternate_routing_designator = p_alt_rtg_desg )
2204: WHERE common_routing_sequence_id IN

Line 2205: ( SELECT routing_Sequence_id FROM bom_operational_routings

2201: WHERE assembly_item_id = p_ass_itm_id
2202: AND organization_id = p_org_id
2203: AND alternate_routing_designator = p_alt_rtg_desg )
2204: WHERE common_routing_sequence_id IN
2205: ( SELECT routing_Sequence_id FROM bom_operational_routings
2206: WHERE assembly_item_id = p_ass_itm_id
2207: AND organization_id = p_org_id
2208: AND alternate_routing_designator IS NULL )
2209: AND common_assembly_item_id IN

Line 2210: ( SELECT assembly_item_id FROM bom_operational_routings

2206: WHERE assembly_item_id = p_ass_itm_id
2207: AND organization_id = p_org_id
2208: AND alternate_routing_designator IS NULL )
2209: AND common_assembly_item_id IN
2210: ( SELECT assembly_item_id FROM bom_operational_routings
2211: WHERE assembly_item_id = p_ass_itm_id
2212: AND organization_id = p_org_id
2213: AND alternate_routing_designator IS NULL );
2214:

Line 2226: UPDATE bom_operational_routings

2222: )
2223: IS
2224: BEGIN
2225:
2226: UPDATE bom_operational_routings
2227: SET common_assembly_item_id =
2228: ( SELECT assembly_item_id
2229: FROM bom_operational_routings
2230: WHERE assembly_item_id = p_ass_itm_id

Line 2229: FROM bom_operational_routings

2225:
2226: UPDATE bom_operational_routings
2227: SET common_assembly_item_id =
2228: ( SELECT assembly_item_id
2229: FROM bom_operational_routings
2230: WHERE assembly_item_id = p_ass_itm_id
2231: AND organization_id = p_org_id
2232: AND alternate_routing_designator IS NULL )
2233: , common_routing_sequence_id =

Line 2235: FROM bom_operational_routings

2231: AND organization_id = p_org_id
2232: AND alternate_routing_designator IS NULL )
2233: , common_routing_sequence_id =
2234: ( SELECT routing_sequence_id
2235: FROM bom_operational_routings
2236: WHERE assembly_item_id = p_ass_itm_id
2237: AND organization_id = p_org_id
2238: AND alternate_routing_designator IS NULL )
2239: , completion_subinventory =

Line 2241: FROM bom_operational_routings

2237: AND organization_id = p_org_id
2238: AND alternate_routing_designator IS NULL )
2239: , completion_subinventory =
2240: ( SELECT completion_subinventory
2241: FROM bom_operational_routings
2242: WHERE assembly_item_id = p_ass_itm_id
2243: AND organization_id = p_org_id
2244: AND alternate_routing_designator IS NULL )
2245: , completion_locator_id =

Line 2247: FROM bom_operational_routings

2243: AND organization_id = p_org_id
2244: AND alternate_routing_designator IS NULL )
2245: , completion_locator_id =
2246: ( SELECT completion_locator_id
2247: FROM bom_operational_routings
2248: WHERE assembly_item_id = p_ass_itm_id
2249: AND organization_id = p_org_id
2250: AND alternate_routing_designator IS NULL )
2251: , alternate_routing_designator =

Line 2365: FROM bom_operational_routings

2361: sql_stmt_num := 10;
2362:
2363: SELECT common_routing_sequence_id
2364: INTO x_from_sequence_id
2365: FROM bom_operational_routings
2366: WHERE routing_sequence_id = from_sequence_id;
2367:
2368: IF (from_org_id <> to_org_id)
2369: THEN

Line 2594: bom_operational_routings bor

2590: -- There should not be any no data found for this case
2591: SELECT
2592: assembly_item_id INTO l_from_item_id
2593: FROM
2594: bom_operational_routings bor
2595: WHERE
2596: bor.routing_sequence_id = from_sequence_id;
2597: INSERT INTO mtl_interface_errors
2598: (unique_id,

Line 3795: bom_operational_routings a

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

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

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';
3799:
3800: --end bug fix 3473851
3801: IF (from_org_id = to_org_id)
3802: THEN

Line 3873: (x_from_entity_name => 'BOM_OPERATIONAL_ROUTINGS',

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

Line 3879: x_to_entity_name => 'BOM_OPERATIONAL_ROUTINGS',

3875: x_from_pk2_value => '',
3876: x_from_pk3_value => '',
3877: x_from_pk4_value => '',
3878: x_from_pk5_value => '',
3879: x_to_entity_name => 'BOM_OPERATIONAL_ROUTINGS',
3880: x_to_pk1_value => p_to_sequence_id,
3881: x_to_pk2_value => '',
3882: x_to_pk3_value => '',
3883: x_to_pk4_value => '',