APPS.BOMPVALR dependencies on BOM_OPERATIONAL_ROUTINGS

Line 960: from bom_operational_routings

956: stmt_num := 7;
957: begin
958: select 'Is pointing to a common'
959: into dummy
960: from bom_operational_routings
961: where routing_sequence_id = c1rec.RSI
962: and common_routing_sequence_id <> c1rec.RSI;
963:
964: ret_code := INVPUOPI.mtl_log_interface_err(

Line 1983: from bom_operational_routings

1979: dummy_rtg := 0;
1980:
1981: select count(*)
1982: into dummy_rtg
1983: from bom_operational_routings
1984: where organization_id = c0rec.OI
1985: and assembly_item_id = c0rec.AII;
1986:
1987: if (dummy_rtg = 0) then

Line 2244: from bom_operational_routings

2240: */
2241: begin
2242: select routing_sequence_id
2243: into cnt
2244: from bom_operational_routings
2245: where routing_sequence_id = cmn_rtg_id
2246: and nvl(alternate_routing_designator, 'NONE') =
2247: nvl(alt_desg, 'NONE')
2248: and common_routing_sequence_id = routing_sequence_id

Line 2388: from bom_operational_routings

2384: */
2385: begin
2386: select routing_sequence_id
2387: into cnt
2388: from bom_operational_routings
2389: where routing_sequence_id = rtg_seq_id;
2390: if (mode_type = 2) then
2391: return(0);
2392: else

Line 2479: from bom_operational_routings

2475: BEGIN
2476: begin
2477: select routing_sequence_id
2478: into cnt
2479: from bom_operational_routings
2480: where organization_id = org_id
2481: and assembly_item_id = assy_id
2482: and nvl(alternate_routing_designator, 'NONE') =
2483: nvl(alt_desg, 'NONE');

Line 2526: from bom_operational_routings

2522: if (alt_desg is not null) then
2523: begin
2524: select routing_sequence_id
2525: into cnt
2526: from bom_operational_routings
2527: where organization_id = org_id
2528: and assembly_item_id = assy_id
2529: and alternate_routing_designator is null
2530: and ((rtg_type = 2)