資源描述：
《-【優(yōu)秀資料】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
