APPS.CTO_CONFIG_ROUTING_PK dependencies on MTL_SYSTEM_ITEMS

Line 380: mtl_system_items msi,

376:
377: select CAL.CALENDAR_DATE
378: into lEstRelDate
379: from bom_calendar_dates cal,
380: mtl_system_items msi,
381: bom_cto_order_lines bcol,
382: mtl_parameters mp
383: where msi.organization_id = pOrgId
384: and msi.inventory_item_id = pModelId

Line 513: mtl_system_items msi,

509:
510: select CAL.CALENDAR_DATE
511: into lEstRelDate
512: from bom_calendar_dates cal,
513: mtl_system_items msi,
514: bom_cto_order_lines bcol,
515: mtl_parameters mp
516: where msi.organization_id = pOrgId
517: and msi.inventory_item_id = pModelId

Line 839: mtl_system_items si1,

835: os1.implementation_date,
836: x_coordinate,
837: y_coordinate
838: FROM bom_cto_order_lines bcol1,
839: mtl_system_items si1,
840: bom_operational_routings or1,
841: bom_operation_sequences os1
842: WHERE bcol1.line_id = pLineId
843: AND bcol1.inventory_item_id = pModelId

Line 998: mtl_system_items msi,

994: y_coordinate
995:
996: FROM bom_cto_order_lines bcol1, -- components
997: bom_cto_order_lines bcol2, -- parent models or option classes
998: mtl_system_items msi,
999: bom_inventory_components ic1,
1000: bom_bill_of_materials b1,
1001: bom_operational_routings or1,
1002: bom_operation_sequences os1

Line 1210: mtl_system_items si2,

1206: y_coordinate
1207: -- 5336292
1208: FROM bom_operation_sequences os1,
1209: bom_operational_routings or1,
1210: mtl_system_items si2,
1211: bom_inventory_components ic1,
1212: bom_bill_of_materials b1,
1213: mtl_system_items si1
1214: WHERE si1.organization_id = pOrgId

Line 1213: mtl_system_items si1

1209: bom_operational_routings or1,
1210: mtl_system_items si2,
1211: bom_inventory_components ic1,
1212: bom_bill_of_materials b1,
1213: mtl_system_items si1
1214: WHERE si1.organization_id = pOrgId
1215: AND si1.inventory_item_id = pModelId
1216: AND si1.bom_item_type = 1 /* model */
1217: AND b1.organization_id = si1.organization_id

Line 1680: FROM mtl_system_items si1,

1676: os1.net_planning_percent,
1677: os1.implementation_date,
1678: x_coordinate,
1679: y_coordinate
1680: FROM mtl_system_items si1,
1681: bom_cto_order_lines bcol,
1682: bom_operational_routings or1,
1683: bom_operation_sequences os1
1684: WHERE bcol.parent_ato_line_id = pLineId

Line 2054: mtl_system_items si2,

2050: y_coordinate
2051:
2052: FROM bom_operation_sequences os1,
2053: bom_operational_routings or1,
2054: mtl_system_items si2,
2055: bom_inventory_components ic1,
2056: bom_bill_of_materials b1,
2057: mtl_system_items si1,
2058: bom_cto_order_lines bcol /* Model or option class */

Line 2057: mtl_system_items si1,

2053: bom_operational_routings or1,
2054: mtl_system_items si2,
2055: bom_inventory_components ic1,
2056: bom_bill_of_materials b1,
2057: mtl_system_items si1,
2058: bom_cto_order_lines bcol /* Model or option class */
2059: WHERE bcol.parent_ato_line_id = pLineId
2060: AND bcol.component_sequence_id is not null
2061: AND bcol.ordered_quantity <> 0

Line 2855: mtl_system_items msi

2851: AND NVL(bos4.operation_type,1) = NVL(bos2.operation_type, 1)
2852: AND bos1.routing_sequence_id = ( /* find the model routing */
2853: select common_routing_sequence_id --5103316
2854: from bom_operational_routings bor,
2855: mtl_system_items msi
2856: where brif.assembly_item_id = msi.inventory_item_id
2857: and brif.organization_id = msi.organization_id
2858: and bor.assembly_item_id = msi.base_item_id
2859: and bor.organization_id = msi.organization_id

Line 2967: from mtl_System_items

2963: else
2964: lstmtNum := 411;
2965: Select serial_number_control_code
2966: into l_ser_code
2967: from mtl_System_items
2968: where inventory_item_id = pModelId
2969: and organization_id =pOrgId;
2970:
2971: IF PG_DEBUG <> 0 THEN