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.

[Home] [Help]

APPS.BOMCUMYD dependencies on BOM_OPERATION_SEQUENCES

Line 280: SELECT null from bom_operation_sequences

276: op_type IN NUMBER
277: ) RETURN NUMBER IS
278:
279: CURSOR process_chk is
280: SELECT null from bom_operation_sequences
281: WHERE routing_sequence_id = rtg_seq_id
282: and process_op_seq_id is not null;
283:
284: CURSOR line_chk is

Line 285: SELECT null from bom_operation_sequences

281: WHERE routing_sequence_id = rtg_seq_id
282: and process_op_seq_id is not null;
283:
284: CURSOR line_chk is
285: SELECT null from bom_operation_sequences
286: WHERE routing_sequence_id = rtg_seq_id
287: and line_op_seq_id is not null;
288:
289: temp NUMBER := 1;

Line 402: BOM_OPERATION_SEQUENCES bos,

398: CURSOR Cur_Line_Op_Flow_Rtg (v_line NUMBER, v_operation_code VARCHAR2) is
399: SELECT DISTINCT bor.routing_sequence_id, bor.alternate_routing_designator,
400: bor.assembly_item_id
401: FROM BOM_OPERATIONAL_ROUTINGS bor,
402: BOM_OPERATION_SEQUENCES bos,
403: BOM_STANDARD_OPERATIONS bso
404: WHERE bor.ORGANIZATION_ID = current_org_id
405: AND bor.CFM_ROUTING_FLAG = 1
406: AND bor.LINE_ID = v_line

Line 430: BOM_OPERATION_SEQUENCES bos,

426:
427: CURSOR Cur_Item_Line_Op_Flow_Rtg (Item_id NUMBER, v_line NUMBER, v_operation_code VARCHAR2) is
428: SELECT DISTINCT bor.routing_sequence_id, bor.alternate_routing_designator
429: FROM BOM_OPERATIONAL_ROUTINGS bor,
430: BOM_OPERATION_SEQUENCES bos,
431: BOM_STANDARD_OPERATIONS bso
432: WHERE bor.ORGANIZATION_ID = current_org_id
433: AND bor.ASSEMBLY_ITEM_ID = Item_id
434: AND bor.CFM_ROUTING_FLAG = 1