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 515: from bom_cto_order_lines

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

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

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

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

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

Line 773: bom_cto_order_lines bcol

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

Line 805: bom_cto_order_lines bcol,

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

Line 871: bom_cto_order_lines bcol

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

Line 894: ,bom_cto_order_lines bcol

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