DBA Data[Home] [Help]

APPS.AP_RECURRING_INVOICES_PKG dependencies on MTL_SYSTEM_ITEMS

Line 2355: MTL_SYSTEM_ITEMS MSI

2351: --Added below 2 columns forBug#8640313
2352: P_PRODUCT_TYPE, --Product_type
2353: P_PRODUCT_CATEGORY --Product_category
2354: FROM PO_LINE_LOCATIONS_AP_V PLL,
2355: MTL_SYSTEM_ITEMS MSI
2356: WHERE PLL.LINE_LOCATION_ID = P_PO_LINE_LOCATION_ID
2357: AND MSI.INVENTORY_ITEM_ID(+) = PLL.ITEM_ID
2358: AND MSI.ORGANIZATION_ID(+) = P_INVENTORY_ORG_ID;
2359: --