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.GMF_COPY_ITEM_COST dependencies on MTL_ITEM_FLEXFIELDS

Line 651: ' select ''z'' from MTL_ITEM_FLEXFIELDS x'||

647: IF ( pi_range_type = G_ITEM ) THEN
648:
649: l_sql_stmt := l_sql_stmt ||
650: ' AND exists ( '||
651: ' select ''z'' from MTL_ITEM_FLEXFIELDS x'||
652: ' where x.organization_id = cst.organization_id '||
653: ' and x.item_number between :pi_from_range and :pi_to_range '||
654: ' and x.inventory_item_id = cst.inventory_item_id )';
655:

Line 1722: pi_item_from IN mtl_item_flexfields.item_number%TYPE,

1718: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1719: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
1720: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
1721: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1722: pi_item_from IN mtl_item_flexfields.item_number%TYPE,
1723: pi_item_to IN mtl_item_flexfields.item_number%TYPE,
1724: pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%TYPE,
1725: pi_itemcc_to IN mtl_categories_b_kfv.concatenated_segments%TYPE,
1726: pi_rem_repl IN VARCHAR2,

Line 1723: pi_item_to IN mtl_item_flexfields.item_number%TYPE,

1719: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
1720: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
1721: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1722: pi_item_from IN mtl_item_flexfields.item_number%TYPE,
1723: pi_item_to IN mtl_item_flexfields.item_number%TYPE,
1724: pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%TYPE,
1725: pi_itemcc_to IN mtl_categories_b_kfv.concatenated_segments%TYPE,
1726: pi_rem_repl IN VARCHAR2,
1727: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,

Line 2036: ' select 1 from MTL_ITEM_FLEXFIELDS x'||

2032:
2033: IF ( pi_range_type = G_ITEM ) THEN
2034: l_sql_stmt_b := l_sql_stmt_b ||
2035: ' AND exists ( '||
2036: ' select 1 from MTL_ITEM_FLEXFIELDS x'||
2037: ' where x.organization_id = bur.organization_id '||
2038: ' and x.item_number between :pi_from_range and :pi_to_range '||
2039: ' and x.inventory_item_id = bur.inventory_item_id )';
2040: