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 182: --TYPE TAB_BCOL is TABLE of bom_cto_order_lines%rowtype index by binary_integer ;

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

Line 183: TYPE TAB_BCOL is TABLE of bom_cto_order_lines%rowtype index by LONG;

179:
180: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CTO_UTILITY_PK';
181: --Bugfix 9148706: Indexing by LONG
182: --TYPE TAB_BCOL is TABLE of bom_cto_order_lines%rowtype index by binary_integer ;
183: TYPE TAB_BCOL is TABLE of bom_cto_order_lines%rowtype index by LONG;
184: gMrpAssignmentSet number ;
185:
186:
187: --

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

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

Line 227: from bom_cto_order_lines

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

Line 236: bom_cto_order_lines bcol

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

Line 286: from bom_cto_order_lines

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

Line 500: lProgramId bom_cto_order_lines.program_id%type ;

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

Line 544: from bom_cto_order_lines

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

Line 553: from bom_cto_order_lines

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

Line 625: --- from the bom_cto_order_lines_table flag

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

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

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

Line 1599: update bom_cto_order_lines

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

Line 2096: ( p_bcol_line_id bom_cto_order_lines.line_id%type,

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

Line 2146: v_bcol_line_id bom_cto_order_lines.line_id%type ;

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

Line 2147: v_bcol_header_id bom_cto_order_lines.header_id%type ;

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

Line 2148: v_bcol_top_model_line_id bom_cto_order_lines.top_model_line_id%type ;

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

Line 2149: v_bcol_ato_line_id bom_cto_order_lines.ato_line_id%type ;

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

Line 2150: v_bcol_link_to_line_id bom_cto_order_lines.link_to_line_id%type ;

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

Line 2151: v_bcol_inventory_item_id bom_cto_order_lines.inventory_item_id%type ;

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

Line 2152: v_bcol_ship_from_org_id bom_cto_order_lines.ship_from_org_id%type ;

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

Line 2153: v_bcol_component_sequence_id bom_cto_order_lines.component_sequence_id%type ;

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

Line 2154: v_bcol_component_code bom_cto_order_lines.component_code%type ;

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

Line 2155: v_bcol_item_type_code bom_cto_order_lines.item_type_code%type ;

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

Line 2156: v_bcol_schedule_ship_date bom_cto_order_lines.schedule_ship_date%type ;

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

Line 2157: v_bcol_bom_item_type bom_cto_order_lines.bom_item_type%type ;

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

Line 2158: v_bcol_wip_supply_type bom_cto_order_lines.wip_supply_type%type ;

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

Line 2159: v_bcol_ordered_quantity bom_cto_order_lines.ordered_quantity%type ;

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

Line 2160: v_bcol_order_quantity_uom bom_cto_order_lines.order_quantity_uom%type ;

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

Line 2161: v_bcol_config_creation bom_cto_order_lines.config_creation%type ;

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

Line 2162: v_bcol_perform_match bom_cto_order_lines.perform_match%type ;

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

Line 2740: ** insert this information into bom_cto_order_lines table

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

Line 2743: insert into bom_cto_order_lines (

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

Line 2821: insert into bom_cto_order_lines_gt (

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

Line 3053: p_bcol_line_id in bom_cto_order_lines.line_id%type )

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

Line 4266: from bom_cto_order_lines bcol

4262: select level,
4263: bcol.inventory_item_id inventory_item_id,
4264: bcol.ordered_quantity ordered_qty,
4265: bcol.ship_from_org_id ship_from_org_id
4266: from bom_cto_order_lines bcol
4267: start with line_id = p_line_id
4268: connect by link_to_line_id = prior line_id;
4269:
4270:

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

5576: oe_debug_pub.add('CTOUTILB.split_line: split line ' ||
5577: v_config.split_from_line_id , 1);
5578:
5579:
5580: update bom_cto_order_lines set config_item_id = ( select bcol1.config_item_id
5581: from bom_cto_order_lines bcol1
5582: where bcol1.line_id = v_config.split_from_line_id )
5583: where line_id = v_config.line_id ;
5584:

Line 5581: from bom_cto_order_lines bcol1

5577: v_config.split_from_line_id , 1);
5578:
5579:
5580: update bom_cto_order_lines set config_item_id = ( select bcol1.config_item_id
5581: from bom_cto_order_lines bcol1
5582: where bcol1.line_id = v_config.split_from_line_id )
5583: where line_id = v_config.line_id ;
5584:
5585: oe_debug_pub.add('CTOUTILB.split_line: update cnt ' || SQL%ROWCOUNT , 1);

Line 5618: update bom_cto_order_lines bcol

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

Line 5641: update bom_cto_order_lines bcol

5637: begin
5638:
5639: oe_debug_pub.add('CTO_UTILITY_PK.adjust_bcol_for_warehouse: entered ' || p_ato_line_id , 1);
5640:
5641: update bom_cto_order_lines bcol
5642: set ship_from_org_id = ( select ship_from_org_id
5643: from oe_order_lines_all
5644: where ato_line_id = bcol.ato_line_id
5645: and line_id = bcol.line_id )

Line 5748: insert into bom_cto_order_lines (

5744: begin
5745:
5746: oe_debug_pub.add( ' entered copy bcol_gt to bcol' , 1) ;
5747:
5748: insert into bom_cto_order_lines (
5749: LINE_ID
5750: ,HEADER_ID
5751: ,TOP_MODEL_LINE_ID
5752: ,LINK_TO_LINE_ID

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

5777: ,REUSE_CONFIG
5778: ,OPTION_SPECIFIC
5779: ,QTY_PER_PARENT_MODEL
5780: ,CONFIG_CREATION)
5781: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
5782: LINE_ID
5783: ,HEADER_ID
5784: ,TOP_MODEL_LINE_ID
5785: ,LINK_TO_LINE_ID

Line 5814: from bom_cto_order_lines_gt

5810: ,REUSE_CONFIG
5811: ,OPTION_SPECIFIC
5812: ,QTY_PER_PARENT_MODEL
5813: ,CONFIG_CREATION
5814: from bom_cto_order_lines_gt
5815: where ato_line_id = p_ato_line_id ;
5816:
5817: oe_debug_pub.add( ' copied bcol_gt to bcol ' || SQL%ROWCOUNT , 1) ;
5818:

Line 5837: delete from bom_cto_order_lines_gt

5833: begin
5834:
5835: oe_debug_pub.add( ' entered copy bcol to bcol_gt ' , 1) ;
5836: --bugfix#3756670
5837: delete from bom_cto_order_lines_gt
5838: where ato_line_id = p_ato_line_id ;
5839:
5840: insert into bom_cto_order_lines_gt (
5841: LINE_ID

Line 5840: insert into bom_cto_order_lines_gt (

5836: --bugfix#3756670
5837: delete from bom_cto_order_lines_gt
5838: where ato_line_id = p_ato_line_id ;
5839:
5840: insert into bom_cto_order_lines_gt (
5841: LINE_ID
5842: ,HEADER_ID
5843: ,TOP_MODEL_LINE_ID
5844: ,LINK_TO_LINE_ID

Line 5908: from bom_cto_order_lines

5904: ,OPTION_SPECIFIC
5905: ,QTY_PER_PARENT_MODEL
5906: ,CONFIG_CREATION
5907: ,SHIP_FROM_ORG_ID --3555026
5908: from bom_cto_order_lines
5909: where ato_line_id = p_ato_line_id ;
5910:
5911:
5912:

Line 6633: from bom_cto_order_lines bcol

6629:
6630: Cursor config_items_cur is
6631: Select bcol.line_id,
6632: bcol.config_item_id
6633: from bom_cto_order_lines bcol
6634: where ato_line_id = p_ato_line_id
6635: and config_item_id is not null;
6636:
6637: Cursor config_orgs_cur(p_config_item_id Number) is

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

6718:
6719:
6720: -- bugfix 4044709 : Created new procedure to handle validation
6721:
6722: PROCEDURE validate_oe_data ( p_bcol_line_id in bom_cto_order_lines.line_id%type,
6723: x_return_status out NOCOPY varchar2)
6724: is
6725:
6726: v_step VARCHAR2(15) ;

Line 6754: from bom_cto_order_lines

6750: -- This is to avoid situations as mentioned in bug 3443450
6751: --
6752:
6753: select count(*) into bcol_count
6754: from bom_cto_order_lines
6755: where ato_line_id = p_bcol_line_id;
6756:
6757: select count(*) into oe_count
6758: from oe_order_lines_all

Line 6791: from bom_cto_order_lines bcol

6787: Where not exists
6788: ( Select bcol.line_id,
6789: bcol.ordered_quantity,
6790: bcol.inventory_item_id
6791: from bom_cto_order_lines bcol
6792: where bcol.ato_line_id = p_bcol_line_id
6793: and bcol.line_id = oel.line_id
6794: and bcol.ordered_quantity = oel.ordered_quantity
6795: and bcol.inventory_item_id = oel.inventory_item_id

Line 6803: from bom_cto_order_lines bcol

6799: AND oel.item_type_code <>'CONFIG'
6800: AND oel.ordered_quantity > 0 ) -- Added this condition to take care of cancel line cases.
6801: UNION
6802: (Select 1
6803: from bom_cto_order_lines bcol
6804: Where not exists
6805: ( Select oel.line_id,
6806: oel.ordered_quantity,
6807: oel.inventory_item_id

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

6945: select nvl(decode(bcolOptions.line_id, bcolModel.line_id, bcolOptions.inventory_item_id,
6946: bcolOptions.config_item_id),
6947: bcolOptions.inventory_item_id) COMPONENT_ITEM_ID
6948: from
6949: bom_cto_order_lines_gt bcolModel, -- Model /* sushant made changes for bug 4341156 */
6950: bom_cto_order_lines_gt bcolOptions -- Options /* sushant made changes for bug 4341156 */
6951: where bcolModel.line_id = p_line_id
6952: and (bcolOptions.parent_ato_line_id = bcolModel.line_id or
6953: bcolOptions.line_id = bcolModel.line_id)

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

6946: bcolOptions.config_item_id),
6947: bcolOptions.inventory_item_id) COMPONENT_ITEM_ID
6948: from
6949: bom_cto_order_lines_gt bcolModel, -- Model /* sushant made changes for bug 4341156 */
6950: bom_cto_order_lines_gt bcolOptions -- Options /* sushant made changes for bug 4341156 */
6951: where bcolModel.line_id = p_line_id
6952: and (bcolOptions.parent_ato_line_id = bcolModel.line_id or
6953: bcolOptions.line_id = bcolModel.line_id)
6954: order by 1;