INV：物料搬运单数据抓取

方便仓库查询按时间段或员工号，进行查询搬运单已经处理与没有处理的数据[@more@]SELECT a.request_number,
a.transaction_type_name,
--a.move_order_type,
a.move_order_type_name,
a.line_number,
msi.SEGMENT1 item,
msi.DESCRIPTION item_desc,
--a.inventory_item_id,
a.from_subinventory_code,
a.to_subinventory_code,
--a.unit_number,
a.uom_code,
a.quantity,
a.required_quantity,
a.quantity_delivered,
a.quantity_detailed,
a.date_required,
--a.reason_id,
a.REFERENCE,
--a.reference_type_code,
--a.line_status,
mfg.MEANING line_status,
--a.status_date,
a.last_updated_by,
fu2.USER_NAME last_updated_name,
a.last_update_date,
a.created_by,
fu1.USER_NAME create_by_name,
a.creation_date,
a.from_sub_quantity_tracked,
a.primary_quantity
FROM mtl_txn_request_lines_v a,
mtl_system_items_b msi,
fnd_user fu1,
fnd_user fu2,
mfg_lookups mfg
WHERE a.organization_id = '104'
--AND ( a.move_order_type != 6
-- AND a.line_status IN (3, 7, 9)
-- )
and a.ORGANIZATION_ID=msi.ORGANIZATION_ID
and a.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
and a.CREATED_BY=fu1.USER_ID
and a.LAST_UPDATED_BY=fu2.USER_ID
and mfg.lookup_type = 'MTL_TXN_REQUEST_STATUS'
AND mfg.lookup_code = TO_CHAR (a.line_status)
ORDER BY request_number, move_order_type_name, line_number

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/41594/viewspace-1015857/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/41594/viewspace-1015857/