APPS.CTO_CONFIG_ROUTING_PK dependencies on BOM_CTO_ORDER_LINES

Line 278: v_program_id bom_cto_order_lines.program_id%type;

274: d_op_seq_num bom_operation_sequences_temp.operation_seq_num%TYPE;
275: d_cfg_rtg_id bom_operation_sequences_temp.config_routing_id%TYPE;
276:
277:
278: v_program_id bom_cto_order_lines.program_id%type;
279:
280: -- 3093686 : structure declaration
281:
282: TYPE mod_opclass_rtg_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 349: from bom_cto_order_lines

345: lStmtNum := 05;
346:
347: select nvl(schedule_ship_date,sysdate)
348: into g_SchShpDate
349: from bom_cto_order_lines
350: where line_id = pLineId ;
351: -- and ship_from_org_id = pOrgId ** bugfix 2312199 **
352: /* commented line as part of bugfix 2312199, the bug 1912376 was not fixed
353: ** properly, the bugfix will not work in case of sourced lower level models

Line 381: bom_cto_order_lines bcol,

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
385: and bcol.line_id = pLineId

Line 417: from bom_cto_order_lines

413: -- Sushant added this code to check bcol records populated by preconfigure bom module
414:
415: select program_id
416: into v_program_id
417: from bom_cto_order_lines
418: where line_id = pLineId ;
419:
420:
421:

Line 469: from bom_cto_order_lines bcol

465: loop
466: select bcol.line_id, bcol.inventory_item_id, bcol.parent_ato_line_id,
467: bcol.ordered_quantity
468: into lLineId, lModelId, lParentAtoLineId, lOrderedQty
469: from bom_cto_order_lines bcol
470: where bcol.line_id = lParentAtoLineId;
471:
472: IF PG_DEBUG <> 0 THEN
473: oe_debug_pub.add('create_routing_ml: ' || 'lLineId: ' || to_char(lLineId), 2);

Line 514: bom_cto_order_lines bcol,

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
518: and bcol.line_id = pLineId

Line 838: FROM bom_cto_order_lines bcol1,

834: os1.net_planning_percent,
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

Line 996: FROM bom_cto_order_lines bcol1, -- components

992: os1.implementation_date,
993: x_coordinate,
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,

Line 997: bom_cto_order_lines bcol2, -- parent models or option classes

993: x_coordinate,
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,

Line 1681: bom_cto_order_lines bcol,

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
1685: AND si1.organization_id = pOrgId

Line 1844: FROM bom_cto_order_lines bcol1, /* components */

1840: os1.net_planning_percent,
1841: os1.implementation_date,
1842: x_coordinate,
1843: y_coordinate
1844: FROM bom_cto_order_lines bcol1, /* components */
1845: bom_cto_order_lines bcol2, /* parents model */
1846: bom_inventory_components ic1,
1847: bom_bill_of_materials b1,
1848: bom_operational_routings or1,

Line 1845: bom_cto_order_lines bcol2, /* parents model */

1841: os1.implementation_date,
1842: x_coordinate,
1843: y_coordinate
1844: FROM bom_cto_order_lines bcol1, /* components */
1845: bom_cto_order_lines bcol2, /* parents model */
1846: bom_inventory_components ic1,
1847: bom_bill_of_materials b1,
1848: bom_operational_routings or1,
1849: bom_operation_sequences os1

Line 2058: bom_cto_order_lines bcol /* Model or option class */

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
2062: AND si1.organization_id = pOrgId