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_BOM_RTG_PK dependencies on BOM_CTO_ORDER_LINES

Line 123: items in bom_cto_order_lines and calls create_in_src_orgs

119:
120: /*-------------------------------------------------------------+
121: Name : Create_all_boms_and_routings
122: This procedure loops through all the configuration
123: items in bom_cto_order_lines and calls create_in_src_orgs
124: for each item.
125: +-------------------------------------------------------------*/
126: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);
127:

Line 163: from bom_cto_order_lines bcol

159:
160: cursor cAllConfigItems is
161: select bcol.line_id, bcol.inventory_item_id,
162: bcol.config_item_id
163: from bom_cto_order_lines bcol
164: --where bcol.top_model_line_id = pTopModelLineId
165: where bcol.ato_line_id = pAtoLineId
166: and bcol.bom_item_type = 1
167: and nvl(bcol.wip_supply_type,0) <> 6

Line 186: select count(*) into v_bcol_count from bom_cto_order_lines

182: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
183:
184:
185:
186: select count(*) into v_bcol_count from bom_cto_order_lines
187: where ato_line_id = pAtoLineId ;
188:
189: oe_debug_pub.add(' CTOBMRTB bcol count ' || v_bcol_count || ' for ' || pAtoLineid , 1);
190:

Line 319: from bom_cto_order_lines

315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316:
317: select ato_line_id, header_id
318: into x_ato_line_id, x_header_id
319: from bom_cto_order_lines
320: where line_id = p_line_id ;
321:
322: IF PG_DEBUG <> 0 THEN
323: oe_debug_pub.add('get_ato_line_id: ' || 'Queried ato_line_id from bcol for given line_id. exiting...', 5);

Line 399: from bom_cto_src_orgs bcso, bom_cto_order_lines bcol, mtl_parameters mp

395: bcso.config_item_id,
396: bcso.group_reference_id
397: -- bcso.cost_rollup, bug 3877317 column will be queried in the cursor
398: -- bcso.organization_type bug 3877317 column will be queried in the cursor
399: from bom_cto_src_orgs bcso, bom_cto_order_lines bcol, mtl_parameters mp
400: where bcso.line_id = pLineId
401: and bcso.model_item_id = pModelId
402: and bcso.config_item_id is not null
403: and bcso.line_id = bcol.line_id

Line 435: from bom_cto_order_lines

431: cursor mismatched_items ( xlineid number,
432: xconfigbillid number,
433: xEstRelDate Date) is
434: select inventory_item_id
435: from bom_cto_order_lines
436: where parent_ato_line_id=xlineid
437: and parent_ato_line_id <> line_id /* to avoid selecting top model */
438: and NOT ( bom_item_type = 1 and wip_supply_type <> 6 and line_id <> xlineid ) /* to avoid selecting lower level models */
439: minus

Line 478: v_program_id bom_cto_order_lines.program_id%type ;

474: l_header_id number;
475: lEstRelDate Date;
476: lLeadTime Number;
477: -- Fix bug 5199775
478: v_program_id bom_cto_order_lines.program_id%type ;
479: v_option_num number := 0 ;
480: v_dropped_item_string varchar2(2000) ;
481: v_sub_dropped_item_string varchar2(2000) ;
482: v_ac_message_string varchar2(2000) ;

Line 518: from bom_cto_order_lines

514:
515: --- Fixed bug 5485452
516: select program_id
517: into v_program_id
518: from bom_cto_order_lines
519: where line_id = pLineId;
520:
521: select count(*) into v_bcol_count from bom_cto_order_lines
522: where ato_line_id = pLineId ;

Line 521: select count(*) into v_bcol_count from bom_cto_order_lines

517: into v_program_id
518: from bom_cto_order_lines
519: where line_id = pLineId;
520:
521: select count(*) into v_bcol_count from bom_cto_order_lines
522: where ato_line_id = pLineId ;
523:
524: oe_debug_pub.add(' bcol count ' || v_bcol_count , 1);
525:

Line 526: select count(*) into v_bcol_count from bom_cto_order_lines

522: where ato_line_id = pLineId ;
523:
524: oe_debug_pub.add(' bcol count ' || v_bcol_count , 1);
525:
526: select count(*) into v_bcol_count from bom_cto_order_lines
527: where ato_line_id = pLineId and option_specific = 'N' ;
528:
529: oe_debug_pub.add(' bcol count ' || v_bcol_count , 1);
530:

Line 776: bom_cto_order_lines bcol

772: select (ceil(nvl(msi.fixed_lead_time,0)
773: + nvl(msi.variable_lead_time,0) * bcol.ordered_quantity))
774: into lLeadTime
775: from mtl_system_items msi,
776: bom_cto_order_lines bcol
777: where bcol.line_id = pLineId
778: and msi.inventory_item_id = bcol.inventory_item_id
779: and msi.organization_id = CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG;
780:

Line 808: bom_cto_order_lines bcol,

804: select CAL.CALENDAR_DATE
805: into lEstRelDate
806: from bom_calendar_dates cal,
807: mtl_system_items msi,
808: bom_cto_order_lines bcol,
809: mtl_parameters mp
810: where msi.organization_id = lNextRec.organization_id
811: and msi.inventory_item_id = pModelId
812: and bcol.line_id = pLineId

Line 874: bom_cto_order_lines bcol

870: into v_missed_item,
871: v_missed_line_number,
872: v_order_number
873: from mtl_system_items_kfv msi,
874: bom_cto_order_lines bcol
875: where msi.organization_id = bcol.ship_from_org_id
876: and msi.inventory_item_id = bcol.inventory_item_id
877: and bcol.parent_ato_line_id = pLineId
878: and bcol.inventory_item_id = l_missed_item_id

Line 897: ,bom_cto_order_lines bcol

893: v_order_number
894: from mtl_system_items_kfv msi,
895: oe_order_lines_all oel,
896: oe_order_headers_all oeh
897: ,bom_cto_order_lines bcol
898: where msi.organization_id = oel.ship_from_org_id
899: and msi.inventory_item_id = oel.inventory_item_id
900: and oel.header_id = oeh.header_id
901: and oel.inventory_item_id = l_missed_item_id