DBA Data[Home] [Help]

APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 585: MTL_SYSTEM_ITEMS_KFV i,

581: edt.project_task_id --12.2.2 Service Projects Integration
582: FROM CS_ESTIMATE_DETAILS edt,
583: CS_TXN_BILLING_OETXN_ALL tb,
584: CS_TXN_BILLING_TYPES tbt,
585: MTL_SYSTEM_ITEMS_KFV i,
586: CS_INCIDENTS_ALL_B sr,
587: CS_TRANSACTION_TYPES_B tt,
588: cs_billing_type_categories cbtc
589: WHERE edt.incident_id = p_incident_id AND

Line 1696: FROM mtl_system_items

1692:
1693: -- Get the Primary_Unit_of_Measure.
1694: SELECT primary_uom_code
1695: INTO l_unit_code
1696: FROM mtl_system_items
1697: WHERE inventory_item_id = l_inv_item_id AND
1698: organization_id = CS_STD.Get_Item_Valdn_Orgzn_ID;
1699:
1700: l_line_tbl(j).inventory_item_id := l_inv_item_id ;