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 680: ' select ''z'' from MTL_ITEM_FLEXFIELDS x'||

676: IF ( pi_range_type = G_ITEM ) THEN
677:
678: l_sql_stmt := l_sql_stmt ||
679: ' AND exists ( '||
680: ' select ''z'' from MTL_ITEM_FLEXFIELDS x'||
681: ' where x.organization_id = cst.organization_id '||
682: ' and x.item_number between :pi_from_range and :pi_to_range '||
683: ' and x.inventory_item_id = cst.inventory_item_id )';
684:

Line 1758: pi_item_from IN mtl_item_flexfields.item_number%TYPE,

1754: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1755: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
1756: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
1757: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1758: pi_item_from IN mtl_item_flexfields.item_number%TYPE,
1759: pi_item_to IN mtl_item_flexfields.item_number%TYPE,
1760: pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%TYPE,
1761: pi_itemcc_to IN mtl_categories_b_kfv.concatenated_segments%TYPE,
1762: pi_rem_repl IN VARCHAR2,

Line 1759: pi_item_to IN mtl_item_flexfields.item_number%TYPE,

1755: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
1756: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
1757: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1758: pi_item_from IN mtl_item_flexfields.item_number%TYPE,
1759: pi_item_to IN mtl_item_flexfields.item_number%TYPE,
1760: pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%TYPE,
1761: pi_itemcc_to IN mtl_categories_b_kfv.concatenated_segments%TYPE,
1762: pi_rem_repl IN VARCHAR2,
1763: pi_all_periods_from IN gmf_period_statuses.period_code%TYPE,

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

2069:
2070: IF ( pi_range_type = G_ITEM ) THEN
2071: l_sql_stmt_b := l_sql_stmt_b ||
2072: ' AND exists ( '||
2073: ' select 1 from MTL_ITEM_FLEXFIELDS x'||
2074: ' where x.organization_id = bur.organization_id '||
2075: ' and x.item_number between :pi_from_range and :pi_to_range '||
2076: ' and x.inventory_item_id = bur.inventory_item_id )'||
2077: -- Bug: 8461556 Vpedarla added the below condition