资源描述：
《-【优秀资料】oracleERP的SQL脚本》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、oracleERP的SQL脚木库存货位列表・sqlselectinventory_location」d,organization_id,description,subinventory_code$egmentlinventory」ocation_codcfromMTL_ITEM_LOCATIONSorderbysubinventoiy_code,inventory_location_code;库存会计期间・sqlSELECTSTATUS,PERIOD_NAME,PERIOD_NUMBER,PERIOD_YEAR,START_DATE,EN
2、D_DATE,CLOSE_DATE,REC_TYPE,ORGANIZATION」DFROMORG_ACCT_PERIODS_VWHERE((rcc_typc=,ORG_PERIOD,))orderbyEND_DATEdesc;库存组织列・sqlselecta.organization_id,a.nameFROMhr_all_organization_unitsawherea.organization_id>82;事物处理活动列表・sqlselect*frommfg_lookupswherelookup_type='MTL_TRANSACT
3、ION_ACTION,ORDERBYLOOKUP_CODE;事物处理来源类型列表・sqlSELECTTRANSACTION_SOURCE_TYPE_NAME,DESCRIPTION,VALIDATED.FLAG,TRANSACTIONSOURCETYPEID,USERDEHNEDFLAG,DISABLEDATEFROMMTL_TXN_SOURCE_TYPESWHEREUSER_DEHNED_FLAG二Norderbytransaction_source_type_name;接收事物处理・sqlSELECTt.po_hcadcr_id,t.
4、po_linc_id,t.po_rclcasc_id,SUM(DECODE(t.transaction_type,DELIVER；[.quantity,RETURNTORECEIVING1,DECODE(t.destination_type_code,'INVENTORY；-(.quantity,'EXPENSE,-(.quantity,0)，'CORRECT',DECODE(t.destination_type_code,•INVENTORY；(.quantity,'EXPENSE；(.quantity,0),0))deliver_qt
5、ya,SUM(t.po_unit_price*t.currency_conversion_rate*DECODE(t.transaction_type,DELIVER*,t.quantity,•RETURNTORECEIVING1,DECODE(t.destination_type_code,,INVENTORY-(.quantity,•EXPENSE；・t.quantity,0),'CORRECT',DECODE(t.destination_type_code,•INVENTORY；t.quantity,EXPENSE1,(.quan
6、tity,0)，0))deliver_amount,SUM(DECODE(t.transaction_typc,'RECEIVE',t.quantity,RETURNTOVENDOR',-t.quantity,'CORRECT',DECODE(t.destination_type_code,RECEIVING；{.quantity,0),0))receive_qtya,SUM(t.po_unit_pricc*t.currency_conversion_rate*DECODE(t.transaction_type,'RECEIVE',t.q
7、uantity,'RETURNTOVENDOR；-(.quantity,CORRECT',DECODE(t.dcstination_typc_codc,RECEIVING；t.quantity,0),))receive_amount,t.unit_of_measure,rsl.itemjd,rsl.item_revision,rsl.item_description,g.period_year,g.period_number,rsl.from_organization_idFROMpo.rcv_transactionst,apps.org
8、_acct_periods_vg,apps.rcv_shipment_linesrslWHERE(t.transaction_type='DELIVER'ORt.transaction_typ
