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_ITEM_PK dependencies on BOM_CTO_ORDER_LINES_GT

Line 212: delete /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) /

208:
209: if( p_mode = 'AUTOCONFIG' ) then
210:
211:
212: delete /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
213: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;
214:
215: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;
216:

Line 213: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;

209: if( p_mode = 'AUTOCONFIG' ) then
210:
211:
212: delete /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
213: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;
214:
215: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;
216:
217:

Line 215: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;

211:
212: delete /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
213: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;
214:
215: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;
216:
217:
218: begin
219:

Line 390: select /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

386:
387:
388: /* Bug 3441482 */
389: begin
390: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
391: bcol.ship_from_org_id , bcolgt.ship_from_org_id
392: into v_bcol_ship_from_org_id, v_bcolgt_ship_from_org_id
393: from bom_cto_order_lines bcol, bom_cto_order_lines_gt bcolgt
394: where bcol.line_id = bcolgt.line_id and bcol.line_id = pTopAtoLineId ;

Line 393: from bom_cto_order_lines bcol, bom_cto_order_lines_gt bcolgt

389: begin
390: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
391: bcol.ship_from_org_id , bcolgt.ship_from_org_id
392: into v_bcol_ship_from_org_id, v_bcolgt_ship_from_org_id
393: from bom_cto_order_lines bcol, bom_cto_order_lines_gt bcolgt
394: where bcol.line_id = bcolgt.line_id and bcol.line_id = pTopAtoLineId ;
395:
396: exception
397: when others then

Line 412: update /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) /

408: , 5);
409: END IF;
410:
411: /* Bug 3441482 */
412: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
413: bom_cto_order_lines_gt bcolgt set option_specific =
414: ( select option_specific from bom_cto_order_lines bcol
415: where bcolgt.line_id = bcol.line_id )
416: where bcolgt.ato_line_id = pTopAtoLineId ;

Line 413: bom_cto_order_lines_gt bcolgt set option_specific =

409: END IF;
410:
411: /* Bug 3441482 */
412: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
413: bom_cto_order_lines_gt bcolgt set option_specific =
414: ( select option_specific from bom_cto_order_lines bcol
415: where bcolgt.line_id = bcol.line_id )
416: where bcolgt.ato_line_id = pTopAtoLineId ;
417:

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

467: ,REUSE_CONFIG
468: ,OPTION_SPECIFIC
469: ,QTY_PER_PARENT_MODEL
470: ,CONFIG_CREATION)
471: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
472: LINE_ID
473: ,HEADER_ID
474: ,TOP_MODEL_LINE_ID
475: ,LINK_TO_LINE_ID

Line 504: from bom_cto_order_lines_gt

500: ,REUSE_CONFIG
501: ,nvl( option_specific, 'N' )
502: ,QTY_PER_PARENT_MODEL
503: ,CONFIG_CREATION
504: from bom_cto_order_lines_gt
505: where ato_line_id = pTopAtoLineId ;
506: /* add ods and reuse flag */
507:
508: IF PG_DEBUG <> 0 THEN

Line 523: insert into bom_cto_order_lines_gt (

519:
520: oe_debug_pub.add('Create_And_Link_Item: ' || 'copy bcol to bcol_gt ', 5);
521: /* copy bcol data to bcol_temp for matching */
522:
523: insert into bom_cto_order_lines_gt (
524: LINE_ID
525: ,HEADER_ID
526: ,TOP_MODEL_LINE_ID
527: ,LINK_TO_LINE_ID

Line 767: select /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

763:
764:
765: lStmtNum := 55 ;
766:
767: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
768: perform_match , config_item_id into x_match_found , x_top_matched_item_id
769: from bom_cto_order_lines_gt
770: where line_id = pTopAtoLineId ;
771:

Line 769: from bom_cto_order_lines_gt

765: lStmtNum := 55 ;
766:
767: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
768: perform_match , config_item_id into x_match_found , x_top_matched_item_id
769: from bom_cto_order_lines_gt
770: where line_id = pTopAtoLineId ;
771:
772:
773: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM:: perform match data ' ||

Line 799: ( select /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

795:
796:
797: update bom_cto_order_lines bcol
798: set ( bcol.perform_match, bcol.config_item_id ) =
799: ( select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
800: bcol_gt.perform_match, bcol_gt.config_item_id
801: from bom_cto_order_lines_gt bcol_gt
802: where bcol.line_id = bcol_gt.line_id )
803: where bcol.ato_line_id = pTopAtoLineId ;

Line 801: from bom_cto_order_lines_gt bcol_gt

797: update bom_cto_order_lines bcol
798: set ( bcol.perform_match, bcol.config_item_id ) =
799: ( select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
800: bcol_gt.perform_match, bcol_gt.config_item_id
801: from bom_cto_order_lines_gt bcol_gt
802: where bcol.line_id = bcol_gt.line_id )
803: where bcol.ato_line_id = pTopAtoLineId ;
804:
805:

Line 1491: update /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

1487: || ' config_orgs ' || v_bcmo_config_orgs
1488: || ' rows ' || SQL%ROWCOUNT, 1);
1489:
1490:
1491: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1492: bom_cto_order_lines_gt
1493: set config_item_id = lXConfigId
1494: where line_id = v_model_lines.line_id ;
1495:

Line 1492: bom_cto_order_lines_gt

1488: || ' rows ' || SQL%ROWCOUNT, 1);
1489:
1490:
1491: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1492: bom_cto_order_lines_gt
1493: set config_item_id = lXConfigId
1494: where line_id = v_model_lines.line_id ;
1495:
1496: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol_gt ' || lXConfigId

Line 1652: update /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

1648:
1649:
1650: oe_debug_pub.add('Create_All_Items: ' || 'V_PERFORM_MATCH IS ::'|| v_perform_match, 1);
1651:
1652: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1653: bom_cto_order_lines_gt
1654: set config_item_id = lXConfigId
1655: where line_id = v_model_lines.line_id ;
1656:

Line 1653: bom_cto_order_lines_gt

1649:
1650: oe_debug_pub.add('Create_All_Items: ' || 'V_PERFORM_MATCH IS ::'|| v_perform_match, 1);
1651:
1652: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1653: bom_cto_order_lines_gt
1654: set config_item_id = lXConfigId
1655: where line_id = v_model_lines.line_id ;
1656:
1657:

Line 1836: update /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

1832: || ' for ' || v_model_lines.line_id , 1);
1833:
1834:
1835:
1836: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1837: bom_cto_order_lines_gt
1838: set config_item_id = lXConfigId
1839: where line_id = v_model_lines.line_id ;
1840:

Line 1837: bom_cto_order_lines_gt

1833:
1834:
1835:
1836: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1837: bom_cto_order_lines_gt
1838: set config_item_id = lXConfigId
1839: where line_id = v_model_lines.line_id ;
1840:
1841:

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

2099: select count(*) into v_bcol_count from bom_cto_order_lines
2100: where ato_line_id = p_ato_line_id ;
2101:
2102:
2103: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
2104: count(*) into v_bcol_gt_count from bom_cto_order_lines_gt
2105: where ato_line_id = p_ato_line_id ;
2106:
2107:

Line 2104: count(*) into v_bcol_gt_count from bom_cto_order_lines_gt

2100: where ato_line_id = p_ato_line_id ;
2101:
2102:
2103: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
2104: count(*) into v_bcol_gt_count from bom_cto_order_lines_gt
2105: where ato_line_id = p_ato_line_id ;
2106:
2107:
2108: oe_debug_pub.add( ' perform_match bcol count ' || v_bcol_count , 1 ) ;

Line 2266: update /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

2262:
2263:
2264: oe_debug_pub.add( 'perform_match: bcol update ' || SQL%rowcount , 1 ) ;
2265:
2266: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2267: bom_cto_order_lines_gt
2268: set config_item_id = l_x_config_id
2269: where line_id = l_next_rec.line_id;
2270:

Line 2267: bom_cto_order_lines_gt

2263:
2264: oe_debug_pub.add( 'perform_match: bcol update ' || SQL%rowcount , 1 ) ;
2265:
2266: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2267: bom_cto_order_lines_gt
2268: set config_item_id = l_x_config_id
2269: where line_id = l_next_rec.line_id;
2270:
2271:

APPS.CTO_ITEM_PK dependencies on BOM_CTO_ORDER_LINES_GT

Line 212: delete /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */