インストール、動作確認

Acceptance Testing
2.2 Administration master data 2.3 Accounting 2.5 Procurement management 仕入れ 2.6 Sales Management 2.7 Production management
Installation and setup of Eclipse IDE

6/11/2009

M_Transaction / 在庫状況


Stck Report













-- SQL --
SELECT
M_PRODUCT_CATEGORY.NAME AS CATEGORYNAME,
M_PRODUCT.VALUE||'-'||M_PRODUCT.NAME AS NAME,
SUM(MOVEMENTQTY) AS MOVEMENTQTY,
M_LOCATOR.X,
M_LOCATOR.Y,
AD_COLUMN_IDENTIFIER('M_WAREHOUSE', to_char(M_LOCATOR.M_WAREHOUSE_ID), :1) AS WAREHOUSE,
M_LOCATOR.Z, C1.NAME AS UOMMOVEMENTQTY,
M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID,
M_ATTRIBUTESETINSTANCE.DESCRIPTION,
(CASE WHEN M_TRANSACTION.M_PRODUCT_UOM_ID IS NULL THEN (CASE M_PRODUCT.WEIGHT*SUM(M_TRANSACTION.MOVEMENTQTY)
WHEN 0 THEN NULL ELSE M_PRODUCT.WEIGHT*SUM(M_TRANSACTION.MOVEMENTQTY) END) ELSE SUM(M_TRANSACTION.QUANTITYORDER) END ) AS WEIGHT,
(CASE WHEN M_TRANSACTION.M_PRODUCT_UOM_ID IS NULL THEN (CASE WHEN M_PRODUCT.WEIGHT = 0 THEN '' WHEN M_PRODUCT.WEIGHT IS NULL THEN '' ELSE 'Kgs' END) ELSE TO_CHAR(C2.NAME) END) AS UOMWEIGHT,
'' as id
FROM M_PRODUCT
left join M_PRODUCT_CATEGORY on M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID,
M_PRODUCT_UOM
right join M_TRANSACTION on M_TRANSACTION.M_PRODUCT_UOM_ID = M_PRODUCT_UOM.M_PRODUCT_UOM_ID
left join C_UOM C2 on M_PRODUCT_UOM.C_UOM_ID = C2.C_UOM_ID,
M_LOCATOR, C_UOM C1,
M_ATTRIBUTESETINSTANCE
WHERE M_TRANSACTION.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
AND M_TRANSACTION.M_ATTRIBUTESETINSTANCE_ID = M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID
AND M_TRANSACTION.M_LOCATOR_ID = M_LOCATOR.M_LOCATOR_ID
AND M_TRANSACTION.C_UOM_ID = C1.C_UOM_ID
AND M_TRANSACTION.AD_CLIENT_ID IN (0,1000000) AND M_TRANSACTION.AD_ORG_ID IN (0,1000000) AND 1=1
AND M_TRANSACTION.MOVEMENTDATE <> 0
ORDER BY M_PRODUCT_CATEGORY.NAME,M_PRODUCT.VALUE, M_PRODUCT.NAME, M_ATTRIBUTESETINSTANCE.DESCRIPTION,M_LOCATOR.X, M_LOCATOR.Y,
M_LOCATOR.ZSELECT M_PRODUCT_CATEGORY.NAME AS CATEGORYNAME, M_PRODUCT.VALUE||'-'||M_PRODUCT.NAME AS NAME,
SUM(MOVEMENTQTY) AS MOVEMENTQTY,
M_LOCATOR.X, M_LOCATOR.Y,
AD_COLUMN_IDENTIFIER('M_WAREHOUSE', to_char(M_LOCATOR.M_WAREHOUSE_ID), :1) AS WAREHOUSE,
M_LOCATOR.Z, C1.NAME AS UOMMOVEMENTQTY,
M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID,
M_ATTRIBUTESETINSTANCE.DESCRIPTION,
(CASE WHEN M_TRANSACTION.M_PRODUCT_UOM_ID IS NULL THEN (CASE M_PRODUCT.WEIGHT*SUM(M_TRANSACTION.MOVEMENTQTY)
WHEN 0 THEN NULL ELSE M_PRODUCT.WEIGHT*SUM(M_TRANSACTION.MOVEMENTQTY) END) ELSE SUM(M_TRANSACTION.QUANTITYORDER) END) AS WEIGHT,
(CASE WHEN M_TRANSACTION.M_PRODUCT_UOM_ID IS NULL THEN (CASE WHEN M_PRODUCT.WEIGHT = 0 THEN '' WHEN M_PRODUCT.WEIGHT IS NULL THEN '' ELSE 'Kgs' END) ELSE TO_CHAR(C2.NAME) END) AS UOMWEIGHT, '' as id
FROM M_PRODUCT
left join M_PRODUCT_CATEGORY on M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID,
M_PRODUCT_UOM
right join M_TRANSACTION on M_TRANSACTION.M_PRODUCT_UOM_ID = M_PRODUCT_UOM.M_PRODUCT_UOM_ID
left join C_UOM C2 on M_PRODUCT_UOM.C_UOM_ID = C2.C_UOM_ID,
M_LOCATOR, C_UOM C1,
M_ATTRIBUTESETINSTANCE
WHERE M_TRANSACTION.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
AND M_TRANSACTION.M_ATTRIBUTESETINSTANCE_ID = M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID
AND M_TRANSACTION.M_LOCATOR_ID = M_LOCATOR.M_LOCATOR_ID
AND M_TRANSACTION.C_UOM_ID = C1.C_UOM_ID
AND M_TRANSACTION.AD_CLIENT_ID IN (0,1000000) AND M_TRANSACTION.AD_ORG_ID IN (0,1000000) AND 1=1
AND M_TRANSACTION.MOVEMENTDATE <> 0
ORDER BY M_PRODUCT_CATEGORY.NAME,M_PRODUCT.VALUE, M_PRODUCT.NAME, M_ATTRIBUTESETINSTANCE.DESCRIPTION,M_LOCATOR.X, M_LOCATOR.Y, M_LOCATOR.Z

36 件のコメント:

  1. A truly happy person is one who can enjoy the scenery on a detour..............................................

    返信削除
  2. 知足常樂~~有這麼好的文章,人生足矣~~哈哈........................................

    返信削除
  3. 人必須心懷希望,才會活的快樂,日子才過得充實,有意義,有朝氣,有信心。........................................

    返信削除
  4. 失意人前,勿談得意事;得意人前,勿談失意事。..................................................

    返信削除
  5. 看看blog調整心情,又要來繼續工作,大家加油........................................

    返信削除
  6. 死亡是悲哀的,但活得不快樂更悲哀。.........................

    返信削除
  7. 大肚能容,了卻人間多少事,滿腔歡喜,笑開天下古今愁。 ..................................................

    返信削除
  8. [做人難,人難做,難做人] 人.事的艱困與磨難,是一種考驗!要以樂觀歡喜之心,很珍惜地過每一天!^^............................................................

    返信削除
  9. 生存乃是不斷地在內心與靈魂交戰;寫作是坐著審判自己。..................................................

    返信削除
  10. 傻氣的人喜歡給心 雖然每次都被笑了卻得到了別人的心................. ................................................

    返信削除