DBA Data[Home] [Help]

APPS.BOMCUMYD dependencies on BOM_OPERATION_SEQUENCES

Line 238: SELECT null from bom_operation_sequences

234: op_type IN NUMBER
235: ) RETURN NUMBER IS
236:
237: CURSOR process_chk is
238: SELECT null from bom_operation_sequences
239: WHERE routing_sequence_id = rtg_seq_id
240: and process_op_seq_id is not null;
241:
242: CURSOR line_chk is

Line 243: SELECT null from bom_operation_sequences

239: WHERE routing_sequence_id = rtg_seq_id
240: and process_op_seq_id is not null;
241:
242: CURSOR line_chk is
243: SELECT null from bom_operation_sequences
244: WHERE routing_sequence_id = rtg_seq_id
245: and line_op_seq_id is not null;
246:
247: temp NUMBER := 1;

Line 360: BOM_OPERATION_SEQUENCES bos,

356: CURSOR Cur_Line_Op_Flow_Rtg (v_line NUMBER, v_operation_code VARCHAR2) is
357: SELECT DISTINCT bor.routing_sequence_id, bor.alternate_routing_designator,
358: bor.assembly_item_id
359: FROM BOM_OPERATIONAL_ROUTINGS bor,
360: BOM_OPERATION_SEQUENCES bos,
361: BOM_STANDARD_OPERATIONS bso
362: WHERE bor.ORGANIZATION_ID = current_org_id
363: AND bor.CFM_ROUTING_FLAG = 1
364: AND bor.LINE_ID = v_line

Line 388: BOM_OPERATION_SEQUENCES bos,

384:
385: CURSOR Cur_Item_Line_Op_Flow_Rtg (Item_id NUMBER, v_line NUMBER, v_operation_code VARCHAR2) is
386: SELECT DISTINCT bor.routing_sequence_id, bor.alternate_routing_designator
387: FROM BOM_OPERATIONAL_ROUTINGS bor,
388: BOM_OPERATION_SEQUENCES bos,
389: BOM_STANDARD_OPERATIONS bso
390: WHERE bor.ORGANIZATION_ID = current_org_id
391: AND bor.ASSEMBLY_ITEM_ID = Item_id
392: AND bor.CFM_ROUTING_FLAG = 1