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 3450: mtl_system_items_kfv msi

3446: ol.PROJECT_ID,
3447: ol.ACTUAL_SHIPMENT_DATE,
3448: ol.FULFILLMENT_DATE
3449: FROM oe_order_lines_all ol,
3450: mtl_system_items_kfv msi
3451: WHERE ol.header_id = v_header_id
3452: AND ol.inventory_item_id = msi.inventory_item_id
3453: AND msi.organization_id = nvl(ol.ship_from_org_id,
3454: oe_sys_parameters.Value('MASTER_ORGANIZATION_ID')) -- Bug 6215694