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 227: delete /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) /

223:
224: if( p_mode = 'AUTOCONFIG' ) then
225:
226:
227: delete /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
228: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;
229:
230: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;
231:

Line 228: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;

224: if( p_mode = 'AUTOCONFIG' ) then
225:
226:
227: delete /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
228: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;
229:
230: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;
231:
232:

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

226:
227: delete /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
228: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;
229:
230: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;
231:
232:
233: begin
234:

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

401:
402:
403: /* Bug 3441482 */
404: begin
405: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
406: bcol.ship_from_org_id , bcolgt.ship_from_org_id
407: into v_bcol_ship_from_org_id, v_bcolgt_ship_from_org_id
408: from bom_cto_order_lines bcol, bom_cto_order_lines_gt bcolgt
409: where bcol.line_id = bcolgt.line_id and bcol.line_id = pTopAtoLineId ;

Line 408: from bom_cto_order_lines bcol, bom_cto_order_lines_gt bcolgt

404: begin
405: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
406: bcol.ship_from_org_id , bcolgt.ship_from_org_id
407: into v_bcol_ship_from_org_id, v_bcolgt_ship_from_org_id
408: from bom_cto_order_lines bcol, bom_cto_order_lines_gt bcolgt
409: where bcol.line_id = bcolgt.line_id and bcol.line_id = pTopAtoLineId ;
410:
411: exception
412: when others then

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

428: l_oss_check_reqd := 1;
429: end if;
430:
431: /* Bug 3441482 */
432: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
433: bom_cto_order_lines_gt bcolgt set option_specific =
434: ( select option_specific from bom_cto_order_lines bcol
435: where bcolgt.line_id = bcol.line_id )
436: where bcolgt.ato_line_id = pTopAtoLineId ;

Line 433: bom_cto_order_lines_gt bcolgt set option_specific =

429: end if;
430:
431: /* Bug 3441482 */
432: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
433: bom_cto_order_lines_gt bcolgt set option_specific =
434: ( select option_specific from bom_cto_order_lines bcol
435: where bcolgt.line_id = bcol.line_id )
436: where bcolgt.ato_line_id = pTopAtoLineId ;
437:

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

487: ,REUSE_CONFIG
488: ,OPTION_SPECIFIC
489: ,QTY_PER_PARENT_MODEL
490: ,CONFIG_CREATION)
491: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
492: LINE_ID
493: ,HEADER_ID
494: ,TOP_MODEL_LINE_ID
495: ,LINK_TO_LINE_ID

Line 524: from bom_cto_order_lines_gt

520: ,REUSE_CONFIG
521: ,nvl( option_specific, 'N' )
522: ,QTY_PER_PARENT_MODEL
523: ,CONFIG_CREATION
524: from bom_cto_order_lines_gt
525: where ato_line_id = pTopAtoLineId ;
526: /* add ods and reuse flag */
527:
528: IF PG_DEBUG <> 0 THEN

Line 543: insert into bom_cto_order_lines_gt (

539:
540: oe_debug_pub.add('Create_And_Link_Item: ' || 'copy bcol to bcol_gt ', 5);
541: /* copy bcol data to bcol_temp for matching */
542:
543: insert into bom_cto_order_lines_gt (
544: LINE_ID
545: ,HEADER_ID
546: ,TOP_MODEL_LINE_ID
547: ,LINK_TO_LINE_ID

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

817:
818:
819: lStmtNum := 55 ;
820:
821: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
822: perform_match , config_item_id into x_match_found , x_top_matched_item_id
823: from bom_cto_order_lines_gt
824: where line_id = pTopAtoLineId ;
825:

Line 823: from bom_cto_order_lines_gt

819: lStmtNum := 55 ;
820:
821: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
822: perform_match , config_item_id into x_match_found , x_top_matched_item_id
823: from bom_cto_order_lines_gt
824: where line_id = pTopAtoLineId ;
825:
826:
827: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM:: perform match data ' ||

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

849:
850:
851: update bom_cto_order_lines bcol
852: set ( bcol.perform_match, bcol.config_item_id ) =
853: ( select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
854: bcol_gt.perform_match, bcol_gt.config_item_id
855: from bom_cto_order_lines_gt bcol_gt
856: where bcol.line_id = bcol_gt.line_id )
857: where bcol.ato_line_id = pTopAtoLineId ;

Line 855: from bom_cto_order_lines_gt bcol_gt

851: update bom_cto_order_lines bcol
852: set ( bcol.perform_match, bcol.config_item_id ) =
853: ( select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
854: bcol_gt.perform_match, bcol_gt.config_item_id
855: from bom_cto_order_lines_gt bcol_gt
856: where bcol.line_id = bcol_gt.line_id )
857: where bcol.ato_line_id = pTopAtoLineId ;
858:
859:

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

1544: || ' config_orgs ' || v_bcmo_config_orgs
1545: || ' rows ' || SQL%ROWCOUNT, 1);
1546:
1547:
1548: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1549: bom_cto_order_lines_gt
1550: set config_item_id = lXConfigId
1551: where line_id = v_model_lines.line_id ;
1552:

Line 1549: bom_cto_order_lines_gt

1545: || ' rows ' || SQL%ROWCOUNT, 1);
1546:
1547:
1548: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1549: bom_cto_order_lines_gt
1550: set config_item_id = lXConfigId
1551: where line_id = v_model_lines.line_id ;
1552:
1553: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol_gt ' || lXConfigId

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

1705:
1706:
1707: oe_debug_pub.add('Create_All_Items: ' || 'V_PERFORM_MATCH IS ::'|| v_perform_match, 1);
1708:
1709: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1710: bom_cto_order_lines_gt
1711: set config_item_id = lXConfigId
1712: where line_id = v_model_lines.line_id ;
1713:

Line 1710: bom_cto_order_lines_gt

1706:
1707: oe_debug_pub.add('Create_All_Items: ' || 'V_PERFORM_MATCH IS ::'|| v_perform_match, 1);
1708:
1709: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1710: bom_cto_order_lines_gt
1711: set config_item_id = lXConfigId
1712: where line_id = v_model_lines.line_id ;
1713:
1714:

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

1892: || ' for ' || v_model_lines.line_id , 1);
1893:
1894:
1895:
1896: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1897: bom_cto_order_lines_gt
1898: set config_item_id = lXConfigId
1899: where line_id = v_model_lines.line_id ;
1900:

Line 1897: bom_cto_order_lines_gt

1893:
1894:
1895:
1896: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1897: bom_cto_order_lines_gt
1898: set config_item_id = lXConfigId
1899: where line_id = v_model_lines.line_id ;
1900:
1901:

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

2167: select count(*) into v_bcol_count from bom_cto_order_lines
2168: where ato_line_id = p_ato_line_id ;
2169:
2170:
2171: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
2172: count(*) into v_bcol_gt_count from bom_cto_order_lines_gt
2173: where ato_line_id = p_ato_line_id ;
2174:
2175:

Line 2172: count(*) into v_bcol_gt_count from bom_cto_order_lines_gt

2168: where ato_line_id = p_ato_line_id ;
2169:
2170:
2171: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
2172: count(*) into v_bcol_gt_count from bom_cto_order_lines_gt
2173: where ato_line_id = p_ato_line_id ;
2174:
2175:
2176: oe_debug_pub.add( ' perform_match bcol count ' || v_bcol_count , 1 ) ;

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

2330:
2331:
2332: oe_debug_pub.add( 'perform_match: bcol update ' || SQL%rowcount , 1 ) ;
2333:
2334: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2335: bom_cto_order_lines_gt
2336: set config_item_id = l_x_config_id
2337: where line_id = l_next_rec.line_id;
2338:

Line 2335: bom_cto_order_lines_gt

2331:
2332: oe_debug_pub.add( 'perform_match: bcol update ' || SQL%rowcount , 1 ) ;
2333:
2334: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2335: bom_cto_order_lines_gt
2336: set config_item_id = l_x_config_id
2337: where line_id = l_next_rec.line_id;
2338:
2339:

APPS.CTO_ITEM_PK dependencies on BOM_CTO_ORDER_LINES_GT

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