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.CZ_BOM_CONFIG_EXPLOSIONS_PKG dependencies on BOM_CTO_ORDER_LINES_GT

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

1346:
1347: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'PROCESS_CONFIGURATOR_DATA' , 'done CTOMCFGB perform_match ' ) ;
1348:
1349:
1350: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1351: perform_match , config_item_id into x_match_found , x_top_matched_item_id
1352: from bom_cto_order_lines_gt
1353: where line_id = v_ato_line_id ;
1354:

Line 1352: from bom_cto_order_lines_gt

1348:
1349:
1350: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1351: perform_match , config_item_id into x_match_found , x_top_matched_item_id
1352: from bom_cto_order_lines_gt
1353: where line_id = v_ato_line_id ;
1354:
1355: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'PROCESS_CONFIGURATOR_DATA' , 'CTOMCFGB perform_match result ' || x_match_found ) ;
1356:

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

1635:
1636: update bom_cto_order_lines set config_item_id = p_top_predefined_item_id
1637: , perform_match = 'U' where line_id = p_top_ato_line_id ;
1638:
1639: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1640: bom_cto_order_lines_gt
1641: set config_item_id = p_top_predefined_item_id
1642: , perform_match = 'U'
1643: where line_id = p_top_ato_line_id ;

Line 1640: bom_cto_order_lines_gt

1636: update bom_cto_order_lines set config_item_id = p_top_predefined_item_id
1637: , perform_match = 'U' where line_id = p_top_ato_line_id ;
1638:
1639: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1640: bom_cto_order_lines_gt
1641: set config_item_id = p_top_predefined_item_id
1642: , perform_match = 'U'
1643: where line_id = p_top_ato_line_id ;
1644:

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

1649:
1650: update bom_cto_order_lines set config_item_id = p_top_predefined_item_id
1651: , perform_match = 'N' where line_id = p_top_ato_line_id ;
1652:
1653: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1654: bom_cto_order_lines_gt
1655: set config_item_id = p_top_predefined_item_id
1656: , perform_match = 'N'
1657: where line_id = p_top_ato_line_id ;

Line 1654: bom_cto_order_lines_gt

1650: update bom_cto_order_lines set config_item_id = p_top_predefined_item_id
1651: , perform_match = 'N' where line_id = p_top_ato_line_id ;
1652:
1653: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1654: bom_cto_order_lines_gt
1655: set config_item_id = p_top_predefined_item_id
1656: , perform_match = 'N'
1657: where line_id = p_top_ato_line_id ;
1658:

Line 2468: Insert into bom_cto_order_lines_gt(

2464: ' parent line_id ' || p_bcol_tab(i).parent_ato_line_id ||
2465: ' parent qty ' || p_bcol_tab(p_bcol_tab(i).parent_ato_line_id ).ordered_quantity , 1) ;
2466: v_step := i ;
2467:
2468: Insert into bom_cto_order_lines_gt(
2469: HEADER_ID ,
2470: LINE_ID ,
2471: LINK_TO_LINE_ID ,
2472: ATO_LINE_ID ,

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

2675: l_x_config_id := NULL;
2676:
2677:
2678:
2679: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2680: perform_match into l_perform_match
2681: from bom_cto_order_lines_gt
2682: where line_id = l_next_rec.line_id ;
2683:

Line 2681: from bom_cto_order_lines_gt

2677:
2678:
2679: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2680: perform_match into l_perform_match
2681: from bom_cto_order_lines_gt
2682: where line_id = l_next_rec.line_id ;
2683:
2684:
2685:

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

2686: if( l_perform_match = 'N' ) then
2687:
2688: begin
2689:
2690: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2691: bom_cto_order_lines_gt set perform_match = 'N'
2692: where perform_match = 'Y'
2693: and line_id = l_next_rec.parent_ato_line_id ;
2694:

Line 2691: bom_cto_order_lines_gt set perform_match = 'N'

2687:
2688: begin
2689:
2690: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2691: bom_cto_order_lines_gt set perform_match = 'N'
2692: where perform_match = 'Y'
2693: and line_id = l_next_rec.parent_ato_line_id ;
2694:
2695: exception

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

2759:
2760:
2761: /* update the perform match column to 'N' so that this item is canned */
2762: begin
2763: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2764: bom_cto_order_lines_gt
2765: set perform_match = 'N'
2766: where line_id = l_next_rec.line_id
2767: and perform_match = 'Y';

Line 2764: bom_cto_order_lines_gt

2760:
2761: /* update the perform match column to 'N' so that this item is canned */
2762: begin
2763: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2764: bom_cto_order_lines_gt
2765: set perform_match = 'N'
2766: where line_id = l_next_rec.line_id
2767: and perform_match = 'Y';
2768:

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

2778: is attempted against its parent and it is canned
2779: */
2780:
2781: begin
2782: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2783: bom_cto_order_lines_gt
2784: set perform_match = 'N'
2785: where line_id = l_next_rec.parent_ato_line_id
2786: and perform_match = 'Y';

Line 2783: bom_cto_order_lines_gt

2779: */
2780:
2781: begin
2782: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2783: bom_cto_order_lines_gt
2784: set perform_match = 'N'
2785: where line_id = l_next_rec.parent_ato_line_id
2786: and perform_match = 'Y';
2787:

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

2803: || to_char(l_next_rec.line_id)
2804: || ' is ' || to_char(l_x_config_id) ,1);
2805: */
2806:
2807: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2808: bom_cto_order_lines_gt
2809: set config_item_id = l_x_config_id
2810: where line_id = l_next_rec.line_id;
2811:

Line 2808: bom_cto_order_lines_gt

2804: || ' is ' || to_char(l_x_config_id) ,1);
2805: */
2806:
2807: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2808: bom_cto_order_lines_gt
2809: set config_item_id = l_x_config_id
2810: where line_id = l_next_rec.line_id;
2811:
2812: l_stmt_num := 40 ;

APPS.CZ_BOM_CONFIG_EXPLOSIONS_PKG dependencies on BOM_CTO_ORDER_LINES_GT

Line 1350: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */