DBA Data[Home] [Help]

APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 552: MTL_SYSTEM_ITEMS_KFV i,

548: i.item_type item_type_code --6523849
549: FROM CS_ESTIMATE_DETAILS edt,
550: CS_TXN_BILLING_OETXN_ALL tb,
551: CS_TXN_BILLING_TYPES tbt,
552: MTL_SYSTEM_ITEMS_KFV i,
553: CS_INCIDENTS_ALL_B sr,
554: CS_TRANSACTION_TYPES_B tt,
555: cs_billing_type_categories cbtc
556: WHERE edt.incident_id = p_incident_id AND

Line 1570: FROM mtl_system_items

1566:
1567: -- Get the Primary_Unit_of_Measure.
1568: SELECT primary_uom_code
1569: INTO l_unit_code
1570: FROM mtl_system_items
1571: WHERE inventory_item_id = l_inv_item_id AND
1572: organization_id = CS_STD.Get_Item_Valdn_Orgzn_ID;
1573:
1574: l_line_tbl(j).inventory_item_id := l_inv_item_id ;