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.OPI_DBI_INV_CCA_PKG dependencies on MTL_PARAMETERS

Line 1658: mtl_parameters mp

1654: mtl_cycle_count_items mcci,
1655: mtl_cycle_count_classes mccc,
1656: mtl_system_items_b msi,
1657: mtl_secondary_inventories subs,
1658: mtl_parameters mp
1659: -- exact matches are approved at the time entry is completed
1660: -- hence it is not possible that status of a cycle count entry
1661: -- changes once the load is collected for that date range.
1662: WHERE mcce.last_update_date >= l_from_bound_date

Line 1808: mtl_parameters mp,

1804: C_EURO_MISSING_AT_START, C_EURO_START_DATE,
1805: conv.approval_date) approval_date,
1806: conv.func_currency_code
1807: FROM opi_dbi_inv_cca_conv conv,
1808: mtl_parameters mp,
1809: (SELECT /*+ parallel (opi_dbi_inv_cca_stg) */
1810: DISTINCT organization_id, approval_date
1811: FROM opi_dbi_inv_cca_stg) to_conv
1812: WHERE nvl (conv.conversion_rate, -999) < 0 -- null is not fine

Line 1830: mtl_parameters mp,

1826: C_EURO_MISSING_AT_START, C_EURO_START_DATE,
1827: conv.approval_date) approval_date,
1828: conv.func_currency_code
1829: FROM opi_dbi_inv_cca_conv conv,
1830: mtl_parameters mp,
1831: (SELECT /*+ parallel (opi_dbi_inv_cca_stg) */
1832: DISTINCT organization_id, approval_date
1833: FROM opi_dbi_inv_cca_stg) to_conv
1834: WHERE nvl (conv.sec_conversion_rate, 999) < 0 -- null is fine

Line 3422: mtl_parameters mp

3418: mtl_cycle_count_items mcci,
3419: mtl_cycle_count_classes mccc,
3420: mtl_system_items_b msi,
3421: mtl_secondary_inventories subs,
3422: mtl_parameters mp
3423: WHERE mcce.last_update_date >= l_from_bound_date
3424: AND mcce.last_update_date < l_to_bound_date
3425: AND mcce.organization_id = mp.organization_id
3426: AND mcce.entry_status_code = C_COMPLETED_CCA_ENTRY -- 5

Line 3560: mtl_parameters mp,

3556: C_EURO_MISSING_AT_START, C_EURO_START_DATE,
3557: conv.approval_date) approval_date,
3558: conv.func_currency_code
3559: FROM opi_dbi_inv_cca_conv conv,
3560: mtl_parameters mp,
3561: (SELECT
3562: DISTINCT organization_id, approval_date
3563: FROM opi_dbi_inv_cca_stg) to_conv
3564: WHERE nvl (conv.conversion_rate, -999) < 0 -- null is not fine

Line 3581: mtl_parameters mp,

3577: C_EURO_MISSING_AT_START, C_EURO_START_DATE,
3578: conv.approval_date) approval_date,
3579: conv.func_currency_code
3580: FROM opi_dbi_inv_cca_conv conv,
3581: mtl_parameters mp,
3582: (SELECT
3583: DISTINCT organization_id, approval_date
3584: FROM opi_dbi_inv_cca_stg) to_conv
3585: WHERE nvl (conv.sec_conversion_rate, 999) < 0 -- null is fine