DBA Data[Home] [Help]

APPS.OM_SETUP_VALID_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 2527: FROM MTL_SYSTEM_ITEMS_B

2523: IF mstrorg IS NOT NULL THEN
2524: IF arstatus = 'I' THEN
2525: SELECT COUNT(INVENTORY_ITEM_ID)
2526: INTO itmcnt
2527: FROM MTL_SYSTEM_ITEMS_B
2528: WHERE ORGANIZATION_ID = mstrorg
2529: AND MTL_TRANSACTIONS_ENABLED_FLAG = 'Y'
2530: AND CUSTOMER_ORDER_FLAG = 'Y'
2531: AND CUSTOMER_ORDER_ENABLED_FLAG = 'Y'

Line 2542: FROM MTL_SYSTEM_ITEMS_B

2538: AND INVOICE_ENABLED_FLAG = 'Y';
2539: ELSE
2540: SELECT COUNT(INVENTORY_ITEM_ID)
2541: INTO itmcnt
2542: FROM MTL_SYSTEM_ITEMS_B
2543: WHERE ORGANIZATION_ID = mstrorg
2544: AND MTL_TRANSACTIONS_ENABLED_FLAG = 'Y'
2545: AND CUSTOMER_ORDER_FLAG = 'Y'
2546: AND CUSTOMER_ORDER_ENABLED_FLAG = 'Y'