eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_UTILITY_PK dependencies on BOM_CTO_ORDER_LINES

Line 12: | 1. Populate temporary tables bom_cto_order_lines and

Line 181: TYPE TAB_BCOL is TABLE of bom_cto_order_lines%rowtype index by binary_integer ;

177: |
178: +-----------------------------------------------------------------------------*/
179:
180: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CTO_UTILITY_PK';
181: TYPE TAB_BCOL is TABLE of bom_cto_order_lines%rowtype index by binary_integer ;
182: gMrpAssignmentSet number ;
183:
184:
185: --

Line 195: p_bcol_line_id in bom_cto_order_lines.line_id%type ) ;

191:
192: PROCEDURE populate_plan_level ( p_t_bcol in out NOCOPY TAB_BCOL ) ;
193: PROCEDURE populate_parent_ato (
194: p_t_bcol in out NOCOPY TAB_BCOL ,
195: p_bcol_line_id in bom_cto_order_lines.line_id%type ) ;
196: PROCEDURE initialize_assignment_set( x_return_status out NOCOPY varchar2) ;
197:
198:
199:

Line 225: from bom_cto_order_lines

221: select line_id,
222: ato_line_id,
223: inventory_item_id,
224: plan_level
225: from bom_cto_order_lines
226: where ato_line_id = pTopAtoLineId
227: and bom_item_type = 1
228: and nvl(wip_supply_type,0) <> 6
229: order by plan_level;

Line 234: bom_cto_order_lines bcol

230:
231: cursor c_parent_src_orgs is
232: select distinct bcso.organization_id
233: from bom_cto_src_orgs bcso,
234: bom_cto_order_lines bcol
235: where bcol.line_id = lLineId
236: and bcol.parent_ato_line_id = bcso.line_id
237: and bcso.create_bom = 'Y';
238:

Line 284: from bom_cto_order_lines

280:
281: lStmtNumber := 40;
282: select ship_from_org_id
283: into lShipFromOrgId
284: from bom_cto_order_lines
285: where line_id = v_model_lines.line_id;
286:
287: lStmtNumber := 50;
288: IF PG_DEBUG <> 0 THEN

Line 498: lProgramId bom_cto_order_lines.program_id%type ;

494: -- End of addition on 08/26/01 for procuring configuration
495:
496: multiorg_error exception;
497: po_multiorg_error exception;
498: lProgramId bom_cto_order_lines.program_id%type ;
499:
500: v_source_type_code oe_order_lines_all.source_type_code%type ;
501:
502: CURSOR c_circular_src IS

Line 542: from bom_cto_order_lines

538: select ato_line_id,
539: program_id
540: into lTopAtoLineId,
541: lProgramId
542: from bom_cto_order_lines
543: where line_id = pLineId;
544: */
545:
546:

Line 551: from bom_cto_order_lines

547: /* BUG#1957336 Changes introduced by sushant for preconfigure bom */
548:
549: select ato_line_id,parent_ato_line_id, nvl(program_id,0) /* added by sushant for preconfigure bom identification */
550: into lTopAtoLineId,l_parent_ato_line_id, lProgramId
551: from bom_cto_order_lines
552: where line_id = pLineId;
553:
554: -- Get the source type of its parent Model line
555: -- If the parent model is of buy type we should not look for

Line 623: --- from the bom_cto_order_lines_table flag

619:
620: --- The following if condition is added by Renga Kannan
621: --- If the line is part of buy model then we need not look at the sourcing info
622: --- we can keep the parents rcv org as the org for this item also. This can be identified
623: --- from the bom_cto_order_lines_table flag
624:
625:
626: lStmtNumber := 32;
627:

Line 1578: This function updates table bom_cto_order_lines with the config_item_id for

1574: end Get_All_Item_Orgs;
1575:
1576:
1577: /*--------------------------------------------------------------------------+
1578: This function updates table bom_cto_order_lines with the config_item_id for
1579: a given model item.
1580: It is called by "Match" and "Create_Item" programs.
1581: +-------------------------------------------------------------------------*/
1582: FUNCTION Update_Order_Lines(pLineId in number,

Line 1597: update bom_cto_order_lines

1593: --
1594: -- If line exists, update it with the config item id
1595: --
1596: lStmtNumber := 20;
1597: update bom_cto_order_lines
1598: set config_item_id = pConfigId
1599: where line_id = pLineId
1600: and inventory_item_id = pModelId;
1601:

Line 2094: ( p_bcol_line_id bom_cto_order_lines.line_id%type,

2090: END Create_Sourcing_Rules;
2091:
2092:
2093: PROCEDURE populate_bcol
2094: ( p_bcol_line_id bom_cto_order_lines.line_id%type,
2095: x_return_status out NOCOPY varchar2,
2096: x_msg_count out NOCOPY number,
2097: x_msg_data out NOCOPY varchar2,
2098: p_reschedule in varchar2 default 'N')

Line 2144: v_bcol_line_id bom_cto_order_lines.line_id%type ;

2140:
2141:
2142: v_kount number(9) ;
2143: l_return_status varchar2(10) ;
2144: v_bcol_line_id bom_cto_order_lines.line_id%type ;
2145: v_bcol_header_id bom_cto_order_lines.header_id%type ;
2146: v_bcol_top_model_line_id bom_cto_order_lines.top_model_line_id%type ;
2147: v_bcol_ato_line_id bom_cto_order_lines.ato_line_id%type ;
2148: v_bcol_link_to_line_id bom_cto_order_lines.link_to_line_id%type ;

Line 2145: v_bcol_header_id bom_cto_order_lines.header_id%type ;

2141:
2142: v_kount number(9) ;
2143: l_return_status varchar2(10) ;
2144: v_bcol_line_id bom_cto_order_lines.line_id%type ;
2145: v_bcol_header_id bom_cto_order_lines.header_id%type ;
2146: v_bcol_top_model_line_id bom_cto_order_lines.top_model_line_id%type ;
2147: v_bcol_ato_line_id bom_cto_order_lines.ato_line_id%type ;
2148: v_bcol_link_to_line_id bom_cto_order_lines.link_to_line_id%type ;
2149: v_bcol_inventory_item_id bom_cto_order_lines.inventory_item_id%type ;

Line 2146: v_bcol_top_model_line_id bom_cto_order_lines.top_model_line_id%type ;

2142: v_kount number(9) ;
2143: l_return_status varchar2(10) ;
2144: v_bcol_line_id bom_cto_order_lines.line_id%type ;
2145: v_bcol_header_id bom_cto_order_lines.header_id%type ;
2146: v_bcol_top_model_line_id bom_cto_order_lines.top_model_line_id%type ;
2147: v_bcol_ato_line_id bom_cto_order_lines.ato_line_id%type ;
2148: v_bcol_link_to_line_id bom_cto_order_lines.link_to_line_id%type ;
2149: v_bcol_inventory_item_id bom_cto_order_lines.inventory_item_id%type ;
2150: v_bcol_ship_from_org_id bom_cto_order_lines.ship_from_org_id%type ;

Line 2147: v_bcol_ato_line_id bom_cto_order_lines.ato_line_id%type ;

2143: l_return_status varchar2(10) ;
2144: v_bcol_line_id bom_cto_order_lines.line_id%type ;
2145: v_bcol_header_id bom_cto_order_lines.header_id%type ;
2146: v_bcol_top_model_line_id bom_cto_order_lines.top_model_line_id%type ;
2147: v_bcol_ato_line_id bom_cto_order_lines.ato_line_id%type ;
2148: v_bcol_link_to_line_id bom_cto_order_lines.link_to_line_id%type ;
2149: v_bcol_inventory_item_id bom_cto_order_lines.inventory_item_id%type ;
2150: v_bcol_ship_from_org_id bom_cto_order_lines.ship_from_org_id%type ;
2151: v_bcol_component_sequence_id bom_cto_order_lines.component_sequence_id%type ;

Line 2148: v_bcol_link_to_line_id bom_cto_order_lines.link_to_line_id%type ;

2144: v_bcol_line_id bom_cto_order_lines.line_id%type ;
2145: v_bcol_header_id bom_cto_order_lines.header_id%type ;
2146: v_bcol_top_model_line_id bom_cto_order_lines.top_model_line_id%type ;
2147: v_bcol_ato_line_id bom_cto_order_lines.ato_line_id%type ;
2148: v_bcol_link_to_line_id bom_cto_order_lines.link_to_line_id%type ;
2149: v_bcol_inventory_item_id bom_cto_order_lines.inventory_item_id%type ;
2150: v_bcol_ship_from_org_id bom_cto_order_lines.ship_from_org_id%type ;
2151: v_bcol_component_sequence_id bom_cto_order_lines.component_sequence_id%type ;
2152: v_bcol_component_code bom_cto_order_lines.component_code%type ;

Line 2149: v_bcol_inventory_item_id bom_cto_order_lines.inventory_item_id%type ;

2145: v_bcol_header_id bom_cto_order_lines.header_id%type ;
2146: v_bcol_top_model_line_id bom_cto_order_lines.top_model_line_id%type ;
2147: v_bcol_ato_line_id bom_cto_order_lines.ato_line_id%type ;
2148: v_bcol_link_to_line_id bom_cto_order_lines.link_to_line_id%type ;
2149: v_bcol_inventory_item_id bom_cto_order_lines.inventory_item_id%type ;
2150: v_bcol_ship_from_org_id bom_cto_order_lines.ship_from_org_id%type ;
2151: v_bcol_component_sequence_id bom_cto_order_lines.component_sequence_id%type ;
2152: v_bcol_component_code bom_cto_order_lines.component_code%type ;
2153: v_bcol_item_type_code bom_cto_order_lines.item_type_code%type ;

Line 2150: v_bcol_ship_from_org_id bom_cto_order_lines.ship_from_org_id%type ;

2146: v_bcol_top_model_line_id bom_cto_order_lines.top_model_line_id%type ;
2147: v_bcol_ato_line_id bom_cto_order_lines.ato_line_id%type ;
2148: v_bcol_link_to_line_id bom_cto_order_lines.link_to_line_id%type ;
2149: v_bcol_inventory_item_id bom_cto_order_lines.inventory_item_id%type ;
2150: v_bcol_ship_from_org_id bom_cto_order_lines.ship_from_org_id%type ;
2151: v_bcol_component_sequence_id bom_cto_order_lines.component_sequence_id%type ;
2152: v_bcol_component_code bom_cto_order_lines.component_code%type ;
2153: v_bcol_item_type_code bom_cto_order_lines.item_type_code%type ;
2154: v_bcol_schedule_ship_date bom_cto_order_lines.schedule_ship_date%type ;

Line 2151: v_bcol_component_sequence_id bom_cto_order_lines.component_sequence_id%type ;

2147: v_bcol_ato_line_id bom_cto_order_lines.ato_line_id%type ;
2148: v_bcol_link_to_line_id bom_cto_order_lines.link_to_line_id%type ;
2149: v_bcol_inventory_item_id bom_cto_order_lines.inventory_item_id%type ;
2150: v_bcol_ship_from_org_id bom_cto_order_lines.ship_from_org_id%type ;
2151: v_bcol_component_sequence_id bom_cto_order_lines.component_sequence_id%type ;
2152: v_bcol_component_code bom_cto_order_lines.component_code%type ;
2153: v_bcol_item_type_code bom_cto_order_lines.item_type_code%type ;
2154: v_bcol_schedule_ship_date bom_cto_order_lines.schedule_ship_date%type ;
2155: v_bcol_bom_item_type bom_cto_order_lines.bom_item_type%type ;

Line 2152: v_bcol_component_code bom_cto_order_lines.component_code%type ;

2148: v_bcol_link_to_line_id bom_cto_order_lines.link_to_line_id%type ;
2149: v_bcol_inventory_item_id bom_cto_order_lines.inventory_item_id%type ;
2150: v_bcol_ship_from_org_id bom_cto_order_lines.ship_from_org_id%type ;
2151: v_bcol_component_sequence_id bom_cto_order_lines.component_sequence_id%type ;
2152: v_bcol_component_code bom_cto_order_lines.component_code%type ;
2153: v_bcol_item_type_code bom_cto_order_lines.item_type_code%type ;
2154: v_bcol_schedule_ship_date bom_cto_order_lines.schedule_ship_date%type ;
2155: v_bcol_bom_item_type bom_cto_order_lines.bom_item_type%type ;
2156: v_bcol_wip_supply_type bom_cto_order_lines.wip_supply_type%type ;

Line 2153: v_bcol_item_type_code bom_cto_order_lines.item_type_code%type ;

2149: v_bcol_inventory_item_id bom_cto_order_lines.inventory_item_id%type ;
2150: v_bcol_ship_from_org_id bom_cto_order_lines.ship_from_org_id%type ;
2151: v_bcol_component_sequence_id bom_cto_order_lines.component_sequence_id%type ;
2152: v_bcol_component_code bom_cto_order_lines.component_code%type ;
2153: v_bcol_item_type_code bom_cto_order_lines.item_type_code%type ;
2154: v_bcol_schedule_ship_date bom_cto_order_lines.schedule_ship_date%type ;
2155: v_bcol_bom_item_type bom_cto_order_lines.bom_item_type%type ;
2156: v_bcol_wip_supply_type bom_cto_order_lines.wip_supply_type%type ;
2157: v_bcol_ordered_quantity bom_cto_order_lines.ordered_quantity%type ;

Line 2154: v_bcol_schedule_ship_date bom_cto_order_lines.schedule_ship_date%type ;

2150: v_bcol_ship_from_org_id bom_cto_order_lines.ship_from_org_id%type ;
2151: v_bcol_component_sequence_id bom_cto_order_lines.component_sequence_id%type ;
2152: v_bcol_component_code bom_cto_order_lines.component_code%type ;
2153: v_bcol_item_type_code bom_cto_order_lines.item_type_code%type ;
2154: v_bcol_schedule_ship_date bom_cto_order_lines.schedule_ship_date%type ;
2155: v_bcol_bom_item_type bom_cto_order_lines.bom_item_type%type ;
2156: v_bcol_wip_supply_type bom_cto_order_lines.wip_supply_type%type ;
2157: v_bcol_ordered_quantity bom_cto_order_lines.ordered_quantity%type ;
2158: v_bcol_order_quantity_uom bom_cto_order_lines.order_quantity_uom%type ;

Line 2155: v_bcol_bom_item_type bom_cto_order_lines.bom_item_type%type ;

2151: v_bcol_component_sequence_id bom_cto_order_lines.component_sequence_id%type ;
2152: v_bcol_component_code bom_cto_order_lines.component_code%type ;
2153: v_bcol_item_type_code bom_cto_order_lines.item_type_code%type ;
2154: v_bcol_schedule_ship_date bom_cto_order_lines.schedule_ship_date%type ;
2155: v_bcol_bom_item_type bom_cto_order_lines.bom_item_type%type ;
2156: v_bcol_wip_supply_type bom_cto_order_lines.wip_supply_type%type ;
2157: v_bcol_ordered_quantity bom_cto_order_lines.ordered_quantity%type ;
2158: v_bcol_order_quantity_uom bom_cto_order_lines.order_quantity_uom%type ;
2159: v_bcol_config_creation bom_cto_order_lines.config_creation%type ;

Line 2156: v_bcol_wip_supply_type bom_cto_order_lines.wip_supply_type%type ;

2152: v_bcol_component_code bom_cto_order_lines.component_code%type ;
2153: v_bcol_item_type_code bom_cto_order_lines.item_type_code%type ;
2154: v_bcol_schedule_ship_date bom_cto_order_lines.schedule_ship_date%type ;
2155: v_bcol_bom_item_type bom_cto_order_lines.bom_item_type%type ;
2156: v_bcol_wip_supply_type bom_cto_order_lines.wip_supply_type%type ;
2157: v_bcol_ordered_quantity bom_cto_order_lines.ordered_quantity%type ;
2158: v_bcol_order_quantity_uom bom_cto_order_lines.order_quantity_uom%type ;
2159: v_bcol_config_creation bom_cto_order_lines.config_creation%type ;
2160: v_bcol_perform_match bom_cto_order_lines.perform_match%type ;

Line 2157: v_bcol_ordered_quantity bom_cto_order_lines.ordered_quantity%type ;

2153: v_bcol_item_type_code bom_cto_order_lines.item_type_code%type ;
2154: v_bcol_schedule_ship_date bom_cto_order_lines.schedule_ship_date%type ;
2155: v_bcol_bom_item_type bom_cto_order_lines.bom_item_type%type ;
2156: v_bcol_wip_supply_type bom_cto_order_lines.wip_supply_type%type ;
2157: v_bcol_ordered_quantity bom_cto_order_lines.ordered_quantity%type ;
2158: v_bcol_order_quantity_uom bom_cto_order_lines.order_quantity_uom%type ;
2159: v_bcol_config_creation bom_cto_order_lines.config_creation%type ;
2160: v_bcol_perform_match bom_cto_order_lines.perform_match%type ;
2161:

Line 2158: v_bcol_order_quantity_uom bom_cto_order_lines.order_quantity_uom%type ;

2154: v_bcol_schedule_ship_date bom_cto_order_lines.schedule_ship_date%type ;
2155: v_bcol_bom_item_type bom_cto_order_lines.bom_item_type%type ;
2156: v_bcol_wip_supply_type bom_cto_order_lines.wip_supply_type%type ;
2157: v_bcol_ordered_quantity bom_cto_order_lines.ordered_quantity%type ;
2158: v_bcol_order_quantity_uom bom_cto_order_lines.order_quantity_uom%type ;
2159: v_bcol_config_creation bom_cto_order_lines.config_creation%type ;
2160: v_bcol_perform_match bom_cto_order_lines.perform_match%type ;
2161:
2162: v_top_level_found boolean ;

Line 2159: v_bcol_config_creation bom_cto_order_lines.config_creation%type ;

2155: v_bcol_bom_item_type bom_cto_order_lines.bom_item_type%type ;
2156: v_bcol_wip_supply_type bom_cto_order_lines.wip_supply_type%type ;
2157: v_bcol_ordered_quantity bom_cto_order_lines.ordered_quantity%type ;
2158: v_bcol_order_quantity_uom bom_cto_order_lines.order_quantity_uom%type ;
2159: v_bcol_config_creation bom_cto_order_lines.config_creation%type ;
2160: v_bcol_perform_match bom_cto_order_lines.perform_match%type ;
2161:
2162: v_top_level_found boolean ;
2163:

Line 2160: v_bcol_perform_match bom_cto_order_lines.perform_match%type ;

2156: v_bcol_wip_supply_type bom_cto_order_lines.wip_supply_type%type ;
2157: v_bcol_ordered_quantity bom_cto_order_lines.ordered_quantity%type ;
2158: v_bcol_order_quantity_uom bom_cto_order_lines.order_quantity_uom%type ;
2159: v_bcol_config_creation bom_cto_order_lines.config_creation%type ;
2160: v_bcol_perform_match bom_cto_order_lines.perform_match%type ;
2161:
2162: v_top_level_found boolean ;
2163:
2164:

Line 2738: ** insert this information into bom_cto_order_lines table

2734:
2735:
2736: if (nvl( p_reschedule, 'N') = 'N' ) then
2737: /*
2738: ** insert this information into bom_cto_order_lines table
2739: */
2740:
2741: insert into bom_cto_order_lines (
2742: LINE_ID

Line 2741: insert into bom_cto_order_lines (

2737: /*
2738: ** insert this information into bom_cto_order_lines table
2739: */
2740:
2741: insert into bom_cto_order_lines (
2742: LINE_ID
2743: ,HEADER_ID
2744: ,TOP_MODEL_LINE_ID
2745: ,LINK_TO_LINE_ID

Line 2819: insert into bom_cto_order_lines_gt (

2815:
2816: else
2817:
2818:
2819: insert into bom_cto_order_lines_gt (
2820: LINE_ID
2821: ,HEADER_ID
2822: ,TOP_MODEL_LINE_ID
2823: ,LINK_TO_LINE_ID

Line 3051: p_bcol_line_id in bom_cto_order_lines.line_id%type )

3047:
3048:
3049: PROCEDURE populate_parent_ato
3050: ( p_t_bcol in out NOCOPY TAB_BCOL ,
3051: p_bcol_line_id in bom_cto_order_lines.line_id%type )
3052: is
3053: TYPE TABNUM is TABLE of NUMBER index by binary_integer ;
3054: v_raw_line_id TABNUM ;
3055: v_src_point number ;

Line 4242: from bom_cto_order_lines bcol

4238: select level,
4239: bcol.inventory_item_id inventory_item_id,
4240: bcol.ordered_quantity ordered_qty,
4241: bcol.ship_from_org_id ship_from_org_id
4242: from bom_cto_order_lines bcol
4243: start with line_id = p_line_id
4244: connect by link_to_line_id = prior line_id;
4245:
4246:

Line 5556: update bom_cto_order_lines set config_item_id = ( select bcol1.config_item_id

5552: oe_debug_pub.add('CTOUTILB.split_line: split line ' ||
5553: v_config.split_from_line_id , 1);
5554:
5555:
5556: update bom_cto_order_lines set config_item_id = ( select bcol1.config_item_id
5557: from bom_cto_order_lines bcol1
5558: where bcol1.line_id = v_config.split_from_line_id )
5559: where line_id = v_config.line_id ;
5560:

Line 5557: from bom_cto_order_lines bcol1

5553: v_config.split_from_line_id , 1);
5554:
5555:
5556: update bom_cto_order_lines set config_item_id = ( select bcol1.config_item_id
5557: from bom_cto_order_lines bcol1
5558: where bcol1.line_id = v_config.split_from_line_id )
5559: where line_id = v_config.line_id ;
5560:
5561: oe_debug_pub.add('CTOUTILB.split_line: update cnt ' || SQL%ROWCOUNT , 1);

Line 5594: update bom_cto_order_lines bcol

5590: begin
5591:
5592: oe_debug_pub.add('CTO_UTILITY_PK.adjust_bcol_for_split: entered ' || p_ato_line_id , 1);
5593:
5594: update bom_cto_order_lines bcol
5595: set ordered_quantity = ( select ordered_quantity
5596: from oe_order_lines_all
5597: where ato_line_id = bcol.ato_line_id
5598: and line_id = bcol.line_id )

Line 5617: update bom_cto_order_lines bcol

5613: begin
5614:
5615: oe_debug_pub.add('CTO_UTILITY_PK.adjust_bcol_for_warehouse: entered ' || p_ato_line_id , 1);
5616:
5617: update bom_cto_order_lines bcol
5618: set ship_from_org_id = ( select ship_from_org_id
5619: from oe_order_lines_all
5620: where ato_line_id = bcol.ato_line_id
5621: and line_id = bcol.line_id )

Line 5724: insert into bom_cto_order_lines (

5720: begin
5721:
5722: oe_debug_pub.add( ' entered copy bcol_gt to bcol' , 1) ;
5723:
5724: insert into bom_cto_order_lines (
5725: LINE_ID
5726: ,HEADER_ID
5727: ,TOP_MODEL_LINE_ID
5728: ,LINK_TO_LINE_ID

Line 5757: select /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) /

5753: ,REUSE_CONFIG
5754: ,OPTION_SPECIFIC
5755: ,QTY_PER_PARENT_MODEL
5756: ,CONFIG_CREATION)
5757: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
5758: LINE_ID
5759: ,HEADER_ID
5760: ,TOP_MODEL_LINE_ID
5761: ,LINK_TO_LINE_ID

Line 5790: from bom_cto_order_lines_gt

5786: ,REUSE_CONFIG
5787: ,OPTION_SPECIFIC
5788: ,QTY_PER_PARENT_MODEL
5789: ,CONFIG_CREATION
5790: from bom_cto_order_lines_gt
5791: where ato_line_id = p_ato_line_id ;
5792:
5793: oe_debug_pub.add( ' copied bcol_gt to bcol ' || SQL%ROWCOUNT , 1) ;
5794:

Line 5813: delete from bom_cto_order_lines_gt

5809: begin
5810:
5811: oe_debug_pub.add( ' entered copy bcol to bcol_gt ' , 1) ;
5812: --bugfix#3756670
5813: delete from bom_cto_order_lines_gt
5814: where ato_line_id = p_ato_line_id ;
5815:
5816: insert into bom_cto_order_lines_gt (
5817: LINE_ID

Line 5816: insert into bom_cto_order_lines_gt (

5812: --bugfix#3756670
5813: delete from bom_cto_order_lines_gt
5814: where ato_line_id = p_ato_line_id ;
5815:
5816: insert into bom_cto_order_lines_gt (
5817: LINE_ID
5818: ,HEADER_ID
5819: ,TOP_MODEL_LINE_ID
5820: ,LINK_TO_LINE_ID

Line 5884: from bom_cto_order_lines

5880: ,OPTION_SPECIFIC
5881: ,QTY_PER_PARENT_MODEL
5882: ,CONFIG_CREATION
5883: ,SHIP_FROM_ORG_ID --3555026
5884: from bom_cto_order_lines
5885: where ato_line_id = p_ato_line_id ;
5886:
5887:
5888:

Line 6609: from bom_cto_order_lines bcol

6605:
6606: Cursor config_items_cur is
6607: Select bcol.line_id,
6608: bcol.config_item_id
6609: from bom_cto_order_lines bcol
6610: where ato_line_id = p_ato_line_id
6611: and config_item_id is not null;
6612:
6613: Cursor config_orgs_cur(p_config_item_id Number) is

Line 6698: PROCEDURE validate_oe_data ( p_bcol_line_id in bom_cto_order_lines.line_id%type,

6694:
6695:
6696: -- bugfix 4044709 : Created new procedure to handle validation
6697:
6698: PROCEDURE validate_oe_data ( p_bcol_line_id in bom_cto_order_lines.line_id%type,
6699: x_return_status out NOCOPY varchar2)
6700: is
6701:
6702: v_step VARCHAR2(15) ;

Line 6730: from bom_cto_order_lines

6726: -- This is to avoid situations as mentioned in bug 3443450
6727: --
6728:
6729: select count(*) into bcol_count
6730: from bom_cto_order_lines
6731: where ato_line_id = p_bcol_line_id;
6732:
6733: select count(*) into oe_count
6734: from oe_order_lines_all

Line 6767: from bom_cto_order_lines bcol

6763: Where not exists
6764: ( Select bcol.line_id,
6765: bcol.ordered_quantity,
6766: bcol.inventory_item_id
6767: from bom_cto_order_lines bcol
6768: where bcol.ato_line_id = p_bcol_line_id
6769: and bcol.line_id = oel.line_id
6770: and bcol.ordered_quantity = oel.ordered_quantity
6771: and bcol.inventory_item_id = oel.inventory_item_id

Line 6779: from bom_cto_order_lines bcol

6775: AND oel.item_type_code <>'CONFIG'
6776: AND oel.ordered_quantity > 0 ) -- Added this condition to take care of cancel line cases.
6777: UNION
6778: (Select 1
6779: from bom_cto_order_lines bcol
6780: Where not exists
6781: ( Select oel.line_id,
6782: oel.ordered_quantity,
6783: oel.inventory_item_id

Line 6925: bom_cto_order_lines_gt bcolModel, -- Model /* sushant made changes for bug 4341156 */

6921: select nvl(decode(bcolOptions.line_id, bcolModel.line_id, bcolOptions.inventory_item_id,
6922: bcolOptions.config_item_id),
6923: bcolOptions.inventory_item_id) COMPONENT_ITEM_ID
6924: from
6925: bom_cto_order_lines_gt bcolModel, -- Model /* sushant made changes for bug 4341156 */
6926: bom_cto_order_lines_gt bcolOptions -- Options /* sushant made changes for bug 4341156 */
6927: where bcolModel.line_id = p_line_id
6928: and (bcolOptions.parent_ato_line_id = bcolModel.line_id or
6929: bcolOptions.line_id = bcolModel.line_id)

Line 6926: bom_cto_order_lines_gt bcolOptions -- Options /* sushant made changes for bug 4341156 */

6922: bcolOptions.config_item_id),
6923: bcolOptions.inventory_item_id) COMPONENT_ITEM_ID
6924: from
6925: bom_cto_order_lines_gt bcolModel, -- Model /* sushant made changes for bug 4341156 */
6926: bom_cto_order_lines_gt bcolOptions -- Options /* sushant made changes for bug 4341156 */
6927: where bcolModel.line_id = p_line_id
6928: and (bcolOptions.parent_ato_line_id = bcolModel.line_id or
6929: bcolOptions.line_id = bcolModel.line_id)
6930: order by 1;