DBA Data[Home] [Help]

APPS.OE_ORDER_WF_UTIL dependencies on MTL_SYSTEM_ITEMS_KFV

Line 7: item mtl_system_items_kfv.concatenated_segments%TYPE,

3:
4: -- record for dynamic notification body for quote/blanket
5: TYPE line_record IS RECORD (
6: line_num VARCHAR2 (100),
7: item mtl_system_items_kfv.concatenated_segments%TYPE,
8: uom VARCHAR2 (3),
9: quantity NUMBER,
10: unit_selling_price NUMBER,
11: line_amount NUMBER,

Line 4367: FROM oe_order_lines_all ol, mtl_system_items_kfv msi

4363: ol.inventory_item_id, ol.item_type_code, ol.open_flag,
4364: ol.shipped_quantity, ol.ordered_quantity,
4365: ol.source_type_code, ol.ship_from_org_id, ol.project_id,
4366: ol.actual_shipment_date, ol.fulfillment_date
4367: FROM oe_order_lines_all ol, mtl_system_items_kfv msi
4368: WHERE ol.header_id = v_header_id
4369: AND ol.inventory_item_id = msi.inventory_item_id
4370: AND msi.organization_id =
4371: NVL