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.AP_MASS_ADDITIONS_CREATE_PKG dependencies on MTL_SYSTEM_ITEMS

Line 670: FROM MTL_SYSTEM_ITEMS MTLSI

666: DECODE(APIDG.ASSET_CATEGORY_ID , NULL,
667: DECODE(POL.ITEM_ID,
668: NULL, NULL,
669: (SELECT MTLSI.ASSET_CATEGORY_ID
670: FROM MTL_SYSTEM_ITEMS MTLSI
671: WHERE POL.ITEM_ID = MTLSI.INVENTORY_ITEM_ID
672: AND MTLSI.ORGANIZATION_ID = FSP.INVENTORY_ORGANIZATION_ID )),
673: APIDG.ASSET_CATEGORY_ID),
674: NULL,

Line 829: -- mtl_system_items MTLSI,

825: po_headers_all POH,
826: po_lines_all POL,
827: po_vendors POV,
828: po_line_types_b POLT,
829: -- mtl_system_items MTLSI,
830: xla_distribution_links XDL,
831: xla_ae_lines XAL,
832: ap_acct_class_code_gt AAGT ,
833: xla_ae_headers XAH,

Line 1171: FROM MTL_SYSTEM_ITEMS MTLSI

1167: DECODE(APIDG.ASSET_CATEGORY_ID , NULL,
1168: DECODE(POL.ITEM_ID,
1169: NULL, NULL,
1170: (SELECT MTLSI.ASSET_CATEGORY_ID
1171: FROM MTL_SYSTEM_ITEMS MTLSI
1172: WHERE POL.ITEM_ID = MTLSI.INVENTORY_ITEM_ID
1173: AND MTLSI.ORGANIZATION_ID = FSP.INVENTORY_ORGANIZATION_ID )),
1174: APIDG.ASSET_CATEGORY_ID),
1175: NULL,

Line 1334: -- mtl_system_items MTLSI,

1330: po_headers_all POH,
1331: po_lines_all POL,
1332: po_vendors POV,
1333: po_line_types_b POLT,
1334: -- mtl_system_items MTLSI,
1335: xla_distribution_links XDL,
1336: xla_ae_lines XAL,
1337: ap_acct_class_code_gt AAGT ,
1338: xla_ae_headers XAH,

Line 2067: FROM mtl_system_items MTLSI,

2063: AND APID.posted_flag = 'Y'
2064: AND APID.assets_tracking_flag = 'Y'
2065: AND EXISTS -- Added EXISTS for bug 9669334
2066: (SELECT 'X'
2067: FROM mtl_system_items MTLSI,
2068: po_distributions_all POD,
2069: po_line_locations_all PLL,
2070: po_lines_all POL
2071: WHERE POD.po_distribution_id = APID.po_distribution_id

Line 2100: FROM mtl_system_items MTLSI,

2096: AND APID.posted_flag = 'Y'
2097: AND APID.assets_tracking_flag = 'Y'
2098: AND EXISTS -- Added EXISTS for bug 9669334
2099: (SELECT 'X'
2100: FROM mtl_system_items MTLSI,
2101: po_distributions_all POD,
2102: po_line_locations_all PLL,
2103: po_lines_all POL
2104: WHERE POD.po_distribution_id = APID.po_distribution_id