VIEW: APPS.EGO_SBDH_BUYING_QTY_INFO_TPV

Source

View Text - Preformatted

SELECT   NVL(TPAGV.EXTENSION_ID , ITEMAGV.EXTENSION_ID ) EXTENSION_ID ,  NVL(TPAGV.INVENTORY_ITEM_ID , ITEMAGV.INVENTORY_ITEM_ID ) INVENTORY_ITEM_ID ,  NVL(TPAGV.MASTER_ORGANIZATION_ID , ITEMAGV.ORGANIZATION_ID ) MASTER_ORGANIZATION_ID ,  TPAGV.PARTY_SITE_ID PARTY_SITE_ID ,  NVL(TPAGV.AGREED_MINIMUM_BUYING_QTY , ITEMAGV.AGREED_MINIMUM_BUYING_QTY ) AGREED_MINIMUM_BUYING_QTY ,  NVL(TPAGV.AGREED_MAXIMUM_BUYING_QTY , ITEMAGV.AGREED_MAXIMUM_BUYING_QTY ) AGREED_MAXIMUM_BUYING_QTY ,  NVL(TPAGV.START_DATE_MINIMUM_BUYING_QTY , ITEMAGV.START_DATE_MINIMUM_BUYING_QTY ) START_DATE_MINIMUM_BUYING_QTY ,  NVL(TPAGV.END_DATE_MINIMUM_BUYING_QTY , ITEMAGV.END_DATE_MINIMUM_BUYING_QTY ) END_DATE_MINIMUM_BUYING_QTY ,  NVL(TPAGV.START_DATE_MAXIMUM_BUYING_QTY , ITEMAGV.START_DATE_MAXIMUM_BUYING_QTY ) START_DATE_MAXIMUM_BUYING_QTY ,  NVL(TPAGV.END_DATE_MAXIMUM_BUYING_QTY , ITEMAGV.END_DATE_MAXIMUM_BUYING_QTY ) END_DATE_MAXIMUM_BUYING_QTY FROM EGO_SBDH_BUYING_QTY_INFO_AGV ITEMAGV , EGO_SBDH_BUYING_QTY_INFO_TPAGV TPAGV WHERE ITEMAGV.INVENTORY_ITEM_ID = TPAGV.INVENTORY_ITEM_ID(+)    AND ITEMAGV.ORGANIZATION_ID = TPAGV.MASTER_ORGANIZATION_ID(+)  UNION ALL  SELECT   EXTENSION_ID ,  INVENTORY_ITEM_ID ,  MASTER_ORGANIZATION_ID ,  PARTY_SITE_ID ,  AGREED_MINIMUM_BUYING_QTY ,  AGREED_MAXIMUM_BUYING_QTY ,  START_DATE_MINIMUM_BUYING_QTY ,  END_DATE_MINIMUM_BUYING_QTY ,  START_DATE_MAXIMUM_BUYING_QTY ,  END_DATE_MAXIMUM_BUYING_QTY FROM EGO_SBDH_BUYING_QTY_INFO_TPAGV TPAGV WHERE NOT EXISTS ( SELECT 'X'                       FROM EGO_SBDH_BUYING_QTY_INFO_AGV ITEMAGV                     WHERE INVENTORY_ITEM_ID = TPAGV.INVENTORY_ITEM_ID                        AND ORGANIZATION_ID = TPAGV.MASTER_ORGANIZATION_ID )   UNION ALL  SELECT   EXTENSION_ID ,  INVENTORY_ITEM_ID ,  MASTER_ORGANIZATION_ID ,  PARTY_SITE_ID ,  AGREED_MINIMUM_BUYING_QTY ,  AGREED_MAXIMUM_BUYING_QTY ,  START_DATE_MINIMUM_BUYING_QTY ,  END_DATE_MINIMUM_BUYING_QTY ,  START_DATE_MAXIMUM_BUYING_QTY ,  END_DATE_MAXIMUM_BUYING_QTY   FROM (SELECT NULL PARTY_SITE_ID, ITEMAGV.* ,                 ITEMAGV.ORGANIZATION_ID MASTER_ORGANIZATION_ID            FROM EGO_SBDH_BUYING_QTY_INFO_AGV  ITEMAGV          WHERE EXISTS ( SELECT 'X'                                FROM EGO_SBDH_BUYING_QTY_INFO_TPAGV TPAGV                              WHERE INVENTORY_ITEM_ID = ITEMAGV.INVENTORY_ITEM_ID                                 AND MASTER_ORGANIZATION_ID = ITEMAGV.ORGANIZATION_ID                             )         ) 

View Text - HTML Formatted

SELECT NVL(TPAGV.EXTENSION_ID
, ITEMAGV.EXTENSION_ID ) EXTENSION_ID
, NVL(TPAGV.INVENTORY_ITEM_ID
, ITEMAGV.INVENTORY_ITEM_ID ) INVENTORY_ITEM_ID
, NVL(TPAGV.MASTER_ORGANIZATION_ID
, ITEMAGV.ORGANIZATION_ID ) MASTER_ORGANIZATION_ID
, TPAGV.PARTY_SITE_ID PARTY_SITE_ID
, NVL(TPAGV.AGREED_MINIMUM_BUYING_QTY
, ITEMAGV.AGREED_MINIMUM_BUYING_QTY ) AGREED_MINIMUM_BUYING_QTY
, NVL(TPAGV.AGREED_MAXIMUM_BUYING_QTY
, ITEMAGV.AGREED_MAXIMUM_BUYING_QTY ) AGREED_MAXIMUM_BUYING_QTY
, NVL(TPAGV.START_DATE_MINIMUM_BUYING_QTY
, ITEMAGV.START_DATE_MINIMUM_BUYING_QTY ) START_DATE_MINIMUM_BUYING_QTY
, NVL(TPAGV.END_DATE_MINIMUM_BUYING_QTY
, ITEMAGV.END_DATE_MINIMUM_BUYING_QTY ) END_DATE_MINIMUM_BUYING_QTY
, NVL(TPAGV.START_DATE_MAXIMUM_BUYING_QTY
, ITEMAGV.START_DATE_MAXIMUM_BUYING_QTY ) START_DATE_MAXIMUM_BUYING_QTY
, NVL(TPAGV.END_DATE_MAXIMUM_BUYING_QTY
, ITEMAGV.END_DATE_MAXIMUM_BUYING_QTY ) END_DATE_MAXIMUM_BUYING_QTY
FROM EGO_SBDH_BUYING_QTY_INFO_AGV ITEMAGV
, EGO_SBDH_BUYING_QTY_INFO_TPAGV TPAGV
WHERE ITEMAGV.INVENTORY_ITEM_ID = TPAGV.INVENTORY_ITEM_ID(+)
AND ITEMAGV.ORGANIZATION_ID = TPAGV.MASTER_ORGANIZATION_ID(+) UNION ALL SELECT EXTENSION_ID
, INVENTORY_ITEM_ID
, MASTER_ORGANIZATION_ID
, PARTY_SITE_ID
, AGREED_MINIMUM_BUYING_QTY
, AGREED_MAXIMUM_BUYING_QTY
, START_DATE_MINIMUM_BUYING_QTY
, END_DATE_MINIMUM_BUYING_QTY
, START_DATE_MAXIMUM_BUYING_QTY
, END_DATE_MAXIMUM_BUYING_QTY
FROM EGO_SBDH_BUYING_QTY_INFO_TPAGV TPAGV
WHERE NOT EXISTS ( SELECT 'X'
FROM EGO_SBDH_BUYING_QTY_INFO_AGV ITEMAGV
WHERE INVENTORY_ITEM_ID = TPAGV.INVENTORY_ITEM_ID
AND ORGANIZATION_ID = TPAGV.MASTER_ORGANIZATION_ID ) UNION ALL SELECT EXTENSION_ID
, INVENTORY_ITEM_ID
, MASTER_ORGANIZATION_ID
, PARTY_SITE_ID
, AGREED_MINIMUM_BUYING_QTY
, AGREED_MAXIMUM_BUYING_QTY
, START_DATE_MINIMUM_BUYING_QTY
, END_DATE_MINIMUM_BUYING_QTY
, START_DATE_MAXIMUM_BUYING_QTY
, END_DATE_MAXIMUM_BUYING_QTY
FROM (SELECT NULL PARTY_SITE_ID
, ITEMAGV.*
, ITEMAGV.ORGANIZATION_ID MASTER_ORGANIZATION_ID
FROM EGO_SBDH_BUYING_QTY_INFO_AGV ITEMAGV
WHERE EXISTS ( SELECT 'X'
FROM EGO_SBDH_BUYING_QTY_INFO_TPAGV TPAGV
WHERE INVENTORY_ITEM_ID = ITEMAGV.INVENTORY_ITEM_ID
AND MASTER_ORGANIZATION_ID = ITEMAGV.ORGANIZATION_ID ) )