APPS.CTO_CONFIG_ROUTING_PK dependencies on MTL_SYSTEM_ITEMS

Line 381: mtl_system_items msi,

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

Line 502: mtl_system_items msi,

498:
499: select CAL.CALENDAR_DATE
500: into lEstRelDate
501: from bom_calendar_dates cal,
502: mtl_system_items msi,
503: bom_cto_order_lines bcol,
504: mtl_parameters mp
505: where msi.organization_id = pOrgId
506: and msi.inventory_item_id = pModelId

Line 823: mtl_system_items si1,

819: os1.implementation_date,
820: x_coordinate,
821: y_coordinate
822: FROM bom_cto_order_lines bcol1,
823: mtl_system_items si1,
824: bom_operational_routings or1,
825: bom_operation_sequences os1
826: WHERE bcol1.line_id = pLineId
827: AND bcol1.inventory_item_id = pModelId

Line 979: mtl_system_items msi,

975: x_coordinate,
976: y_coordinate
977: FROM bom_cto_order_lines bcol1, -- components
978: bom_cto_order_lines bcol2, -- parent models or option classes
979: mtl_system_items msi,
980: bom_inventory_components ic1,
981: bom_bill_of_materials b1,
982: bom_operational_routings or1,
983: bom_operation_sequences os1

Line 1192: mtl_system_items si2,

1188: y_coordinate
1189: -- 5336292
1190: FROM bom_operation_sequences os1,
1191: bom_operational_routings or1,
1192: mtl_system_items si2,
1193: bom_inventory_components ic1,
1194: bom_bill_of_materials b1,
1195: mtl_system_items si1
1196: WHERE si1.organization_id = pOrgId

Line 1195: mtl_system_items si1

1191: bom_operational_routings or1,
1192: mtl_system_items si2,
1193: bom_inventory_components ic1,
1194: bom_bill_of_materials b1,
1195: mtl_system_items si1
1196: WHERE si1.organization_id = pOrgId
1197: AND si1.inventory_item_id = pModelId
1198: AND si1.bom_item_type = 1 /* model */
1199: AND b1.organization_id = si1.organization_id

Line 1660: FROM mtl_system_items si1,

1656: os1.net_planning_percent,
1657: os1.implementation_date,
1658: x_coordinate,
1659: y_coordinate
1660: FROM mtl_system_items si1,
1661: bom_cto_order_lines bcol,
1662: bom_operational_routings or1,
1663: bom_operation_sequences os1
1664: WHERE bcol.parent_ato_line_id = pLineId

Line 2036: mtl_system_items si2,

2032: y_coordinate
2033:
2034: FROM bom_operation_sequences os1,
2035: bom_operational_routings or1,
2036: mtl_system_items si2,
2037: bom_inventory_components ic1,
2038: bom_bill_of_materials b1,
2039: mtl_system_items si1,
2040: bom_cto_order_lines bcol /* Model or option class */

Line 2039: mtl_system_items si1,

2035: bom_operational_routings or1,
2036: mtl_system_items si2,
2037: bom_inventory_components ic1,
2038: bom_bill_of_materials b1,
2039: mtl_system_items si1,
2040: bom_cto_order_lines bcol /* Model or option class */
2041: WHERE bcol.parent_ato_line_id = pLineId
2042: AND bcol.component_sequence_id is not null
2043: AND bcol.ordered_quantity <> 0

Line 2847: mtl_system_items msi

2843: AND NVL(bos4.operation_type,1) = NVL(bos2.operation_type, 1)
2844: AND bos1.routing_sequence_id = ( /* find the model routing */
2845: select common_routing_sequence_id --5103316
2846: from bom_operational_routings bor,
2847: mtl_system_items msi
2848: where brif.assembly_item_id = msi.inventory_item_id
2849: and brif.organization_id = msi.organization_id
2850: and bor.assembly_item_id = msi.base_item_id
2851: and bor.organization_id = msi.organization_id

Line 2987: from mtl_System_items

2983: else
2984: lstmtNum := 411;
2985: Select serial_number_control_code
2986: into l_ser_code
2987: from mtl_System_items
2988: where inventory_item_id = pModelId
2989: and organization_id =pOrgId;
2990:
2991: IF PG_DEBUG <> 0 THEN