[Home] [Help]
277: d_op_type bom_operation_sequences_temp.operation_type%TYPE;
278: d_op_effective_dt VARCHAR2(40);
279:
280:
281: v_program_id bom_cto_order_lines.program_id%type;
282:
283: -- 3093686 : structure declaration
284:
285: TYPE mod_opclass_rtg_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
348: lStmtNum := 05;
349:
350: select nvl(schedule_ship_date,sysdate)
351: into g_SchShpDate
352: from bom_cto_order_lines
353: where line_id = pLineId ;
354: -- and ship_from_org_id = pOrgId ** bugfix 2312199 **
355: /* commented line as part of bugfix 2312199, the bug 1912376 was not fixed
356: ** properly, the bugfix will not work in case of sourced lower level models
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
386: and bcol.line_id = pLineId
411: -- Sushant added this code to check bcol records populated by preconfigure bom module
412:
413: select program_id
414: into v_program_id
415: from bom_cto_order_lines
416: where line_id = pLineId ;
417:
418: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
419:
459: loop
460: select bcol.line_id, bcol.inventory_item_id, bcol.parent_ato_line_id,
461: bcol.ordered_quantity
462: into lLineId, lModelId, lParentAtoLineId, lOrderedQty
463: from bom_cto_order_lines bcol
464: where bcol.line_id = lParentAtoLineId;
465:
466: IF PG_DEBUG <> 0 THEN
467: oe_debug_pub.add('create_routing_ml: ' || 'lLineId: ' || to_char(lLineId), 2);
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
507: and bcol.line_id = pLineId
818: os1.net_planning_percent,
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
973: os1.net_planning_percent,
974: os1.implementation_date,
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,
974: os1.implementation_date,
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,
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
1665: AND si1.organization_id = pOrgId
1821: os1.net_planning_percent,
1822: os1.implementation_date,
1823: x_coordinate,
1824: y_coordinate
1825: FROM bom_cto_order_lines bcol1, /* components */
1826: bom_cto_order_lines bcol2, /* parents model */
1827: bom_inventory_components ic1,
1828: bom_bill_of_materials b1,
1829: bom_operational_routings or1,
1822: os1.implementation_date,
1823: x_coordinate,
1824: y_coordinate
1825: FROM bom_cto_order_lines bcol1, /* components */
1826: bom_cto_order_lines bcol2, /* parents model */
1827: bom_inventory_components ic1,
1828: bom_bill_of_materials b1,
1829: bom_operational_routings or1,
1830: bom_operation_sequences os1
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
2044: AND si1.organization_id = pOrgId