ITPub博客

select distinct b.segment1, nvl(a.PRIOR_COST,0), nvl(b.unit_weight,0) from apps.mtl_material_transactions a, apps.mtl_system_items b, apps.cst_item_costs c where a.ORGANIZATION_ID=b.ORGANIZATION_ID and a.inventory_item_id=b.inventory_item_id and a.ORGANIZATION_ID=c.ORGANIZATION_ID and a.inventory_item_id=c.inventory_item_id and trunc(a.TRANSACTION_DATE)>=to_date('01-01-2002','MM-DD-YYYY') and trunc(a.TRANSACTION_DATE)<=to_date('04-30-2003','MM

SELECT OEH.ORG_ID,OEL.SHIP_FROM_ORG_ID,OEH.ORDER_NUMBER,OEL.LINE_NUMBER ,OEL.INVENTORY_ITEM_ID,NULL--MSI.SEGMENT1,NULL--MSI.DESCRIPTION ITEM_DESC,NULL--MSI.ITEM_TYPE,NULL--OEL.ORDER_QUANTITY_UOM UOM,NULL--MCB.SEGMENT4 COST_CENTER,NULL--MCB.SEGMENT2 AUX,NULL--MCB.SEGMENT3 CUSTOMS_DUTY,TO_CHAR(DECODE(OEL.ACTUAL_SHIPMENT_DATE,NULL,OEL.FULFILLMENT_DATE,OEL.ACTUAL_SHIPMENT_DATE),'YYYY-MM') SHIPPED_MONTH,NVL(DECODE(OEL.LINE_CATEGORY_CODE,'RETURN',-1 * OEL.SHIPPED_QUANTITY,OEL.SHIPPED_QUANTITY),0) SHIP

SELECT WDJ.ROWID ROW_ID,WDJ.ORGANIZATION_ID,WDJ.WIP_ENTITY_ID,WE.WIP_ENTITY_NAME,WDJ.PRIMARY_ITEM_ID,MSIK.SEGMENT1 FG_ITEM_NUMBER,MSIK.DESCRIPTION FG_ITEM_DESC,MSIK.PRIMARY_UOM_CODE FG_UOM_CODE,WDJ.COMPLETION_SUBINVENTORY,WDJ.SCHEDULED_START_DATE,WDJ.SCHEDULED_COMPLETION_DATE,WDJ.CREATION_DATE,WDJ.CREATED_BY,WDJ.LAST_UPDATE_DATE,WDJ.LAST_UPDATED_BY,WDJ.DESCRIPTION JOB_DESC,WDJ.STATUS_TYPE, WDJ.JOB_TYPE,LU3.MEANING JOB_TYPE_NAME,WDJ.WIP_SUPPLY_TYPE,WDJ.CLASS_CODE,WDJ.DATE_RELEASED,WDJ.DATE_COMPLE