APPS.CSTPACDP dependencies on MTL_SYSTEM_ITEMS_B

Line 7519: FROM mtl_system_items_b

7515: +----------------------------------------------------------------------*/
7516: l_stmt_num := 160;
7517: select decode(inventory_asset_flag,'Y',0,1), nvl(expense_account, -1)
7518: INTO iexp_flg, exp_acct
7519: FROM mtl_system_items_b
7520: WHERE inventory_item_id = item_id
7521: AND organization_id = org_id;
7522:
7523:

Line 7730: FROM mtl_system_items_b send, mtl_system_items_b rec

7726: +----------------------------------------------------------------------*/
7727: l_stmt_num := 460;
7728: select send.primary_uom_code, rec.primary_uom_code
7729: INTO send_uom, rec_uom
7730: FROM mtl_system_items_b send, mtl_system_items_b rec
7731: WHERE send.inventory_item_id = item_id
7732: AND send.organization_id = from_org
7733: AND rec.inventory_item_id = item_id
7734: AND rec.organization_id = to_org;