DBA Data[Home] [Help]

APPS.OKS_ARFEEDER_PUB dependencies on MTL_SYSTEM_ITEMS

Line 329: mtl_system_items mtl

325: SELECT txl.customer_trx_line_id ,txh.trx_date trx_date,
326: txh.exchange_rate_type,txh.exchange_date, txh.exchange_rate
327: FROM ra_customer_trx_all txh ,
328: ra_customer_trx_lines_all txl ,
329: mtl_system_items mtl
330: WHERE txl.interface_line_attribute6 = to_char(p_line_id)
331: AND txl.interface_line_context = 'ORDER ENTRY'
332: AND txh.customer_trx_id = txl.customer_trx_id
333: AND txl.inventory_item_id = mtl.inventory_item_id

Line 995: From mtl_system_items_b

991: WHERE CLE_ID = p_id;
992:
993: Cursor Prim_uom_cur(p_id In NUMBER, p_org_id IN NUMBER) IS
994: SELECT primary_uom_code
995: From mtl_system_items_b
996: WHERE inventory_item_id = p_id
997: AND organization_id = p_org_id;
998:
999: