APPS.CST_TPRICE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 387: FROM mtl_system_items MSI, mtl_parameters MP

383: l_stmt_num := 160;
384:
385: SELECT nvl(MSI.cost_of_sales_account, MP.cost_of_sales_account)
386: INTO l_om_ccid
387: FROM mtl_system_items MSI, mtl_parameters MP
388: WHERE MSI.organization_id = l_from_org
389: AND MSI.inventory_item_id = p_item_id
390: AND MP.organization_id = MSI.organization_id;
391: end if;

Line 457: FROM mtl_system_items_b

453: l_stmt_num := 185;
454:
455: SELECT decode(inventory_asset_flag, 'Y', 0, 1)
456: INTO l_from_exp_item
457: FROM mtl_system_items_b
458: WHERE organization_id = l_from_org
459: AND inventory_item_id = p_item_id;
460:
461: /* Bug 3551024: For an expense item in the sending org, no COGS accounting */