oracle ERP的SQL脚本（最新）.docVIP

/**************************/ oracle ERP的ＳＱＬ脚本 /**************************/ 库存货位列表.sql select inventory_location_id,organization_id,description,subinventory_code,segment1 inventory_location_code from MTL_ITEM_LOCATIONS order by subinventory_code,inventory_location_code; 库存会计期间.sql SELECT STATUS,PERIOD_NAME,PERIOD_NUMBER,PERIOD_YEAR,START_DATE,END_DATE,CLOSE_DATE,REC_TYPE, ORGANIZATION_ID FROM ORG_ACCT_PERIODS_V WHERE ((rec_type = ORG_PERIOD )) order by END_DATE desc; 库存组织列.sql select anization_id, FROM hr_all_organization_units a where anization_id82; 事物处理活动列表.sql select * from mfg_loo