DBA Data[Home] [Help]

APPS.BOM_RTG_COPYORG_IMP dependencies on MTL_PARAMETERS

Line 115: mtl_parameters org,

111: NULL ser_start_op_seq,
112: NULL row_identifier
113: FROM bom_operational_routings bor,
114: wip_lines wl,
115: mtl_parameters org,
116: mtl_system_items_kfv item1,
117: mtl_system_items_kfv item2,
118: mtl_item_locations_kfv locators
119: WHERE wl.line_id(+) = bor.line_id

Line 161: mtl_parameters org,

157: 'CREATE' Transaction_Type,
158: NULL Return_Status,
159: NULL Row_Identifier
160: FROM mtl_rtg_item_revisions rev,
161: mtl_parameters org,
162: mtl_system_items_kfv item
163: WHERE org.organization_id = rev.organization_id
164: AND item.organization_id = rev.organization_id
165: AND item.inventory_item_id = rev.inventory_item_id

Line 230: mtl_parameters org,

226: NULL Long_Description,
227: NULL Row_Identifier
228: FROM bom_operation_sequences_v op_seq,
229: bom_operational_routings rtg,
230: mtl_parameters org,
231: mtl_system_items_kfv item
232: WHERE rtg.routing_sequence_id = op_seq.routing_sequence_id
233: AND org.organization_id = rtg.organization_id
234: AND item.organization_id = rtg.organization_id

Line 293: mtl_parameters org

289: bom_setup_types bst,
290: bom_operation_sequences op_seq,
291: bom_operational_routings rtg,
292: mtl_system_items_kfv item,
293: mtl_parameters org
294: WHERE op_seq.operation_sequence_id = bor.operation_sequence_id
295: AND rtg.routing_sequence_id = op_seq.routing_sequence_id
296: AND org.organization_id = rtg.organization_id
297: AND item.organization_id = rtg.organization_id

Line 357: mtl_parameters org,

353: bst.setup_Code Setup_Type,
354: NULL Row_Identifier
355: FROM bom_sub_operation_resources bsor,
356: mtl_system_items_kfv item,
357: mtl_parameters org,
358: bom_operational_routings rtg,
359: bom_operation_sequences op_seq,
360: bom_resources br,
361: cst_activities ca,

Line 427: mtl_parameters org

423: bom_operation_sequences bos1,
424: bom_operation_sequences bos2,
425: bom_operational_routings rtg,
426: mtl_system_items_kfv item,
427: mtl_parameters org
428: WHERE rtg.routing_sequence_id = bonv.routing_sequence_id
429: AND bos1.Operation_Sequence_Id = bonv.From_Op_Seq_Id
430: AND bos2.Operation_Sequence_Id = bonv.To_Op_Seq_Id
431: AND org.organization_id = rtg.organization_id

Line 477: mtl_parameters org,

473: SELECT COUNT(*)
474: INTO l_hdr_cnt
475: FROM bom_operational_routings bor,
476: wip_lines wl,
477: mtl_parameters org,
478: mtl_system_items_kfv item1,
479: mtl_system_items_kfv item2,
480: mtl_item_locations_kfv locators
481: WHERE wl.line_id(+) = bor.line_id