QP_PRICE_BOOK_LINES

Details

Schema: FUSION
Object owner: QP
Object type: VIEW

Columns

Name
PRICE_BOOK_LINE_ID PRICE_BOOK_ID PRICE_BOOK_START_DATE PRICE_BOOK_END_DATE PRICE_VALID_FROM PRICE_VALID_UNTIL CURRENCY_CODE SYSTEM_GENERATED_FLAG BUSINESS_UNIT_ID INVENTORY_ITEM_ID INVENTORY_ORG_ID INVENTORY_ITEM_NUMBER COMPONENT_ID_PATH COMPONENT_PATH ITEM_TYPE_CODE CATEGORY_CODE PARENT_LINE_ID ROOT_LINE_ID ROOT_COVERAGE_LINE_ID LINE_QUANTITY LINE_QUANTITY_UOM_CODE LINE_TYPE_CODE APPLIED_PRICE_LIST_ID APPLIED_SHIP_CHARGE_LIST_ID RATE_PLAN_ID REQUESTED_RATE_PLAN_ID PRICED_ON CUSTOMER_ID BILL_TO_CUSTOMER_ID BILL_TO_PARTY_ID BILL_TO_PARTY_SITE_ID BILL_TO_LOCATION_ID BILL_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID SHIP_TO_LOCATION_ID SHIP_METHOD_ID SHIP_FROM_PARTY_ID SHIP_TO_PARTY_ID PRICING_STRATEGY_ID AGREEMENT_HEADER_ID AGREEMENT_LINE_ID AGREEMENT_VERSION_NUMBER ADDITIONAL_ATTRS ACTION_TYPE_CODE SERVICE_DURATION SERVICE_DURATION_PERIOD_CODE SERVICE_START_DATE SERVICE_DURATION_TYPE_CODE ITEM_CATALOG_GROUP_ID STYLE_ITEM_ID STYLE_ITEM_FLAG SERVICE_END_DATE PRICE_BOOK_REQUEST_ID BATCH_ID CHILD_BATCH_ID ESS_CHILD_PROCESS_ID STATUS_CODE SALES_PRODUCT_TYPE CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER COVERED_ITEM_UOM_CODE COVERAGE_DURATION_UOM_CODE COVERAGE_DURATION RATE_PLAN_NUMBER PB_LINES_START_DATE PB_LINES_END_DATE

Name

PRICE_BOOK_LINE_ID

PRICE_BOOK_ID

PRICE_BOOK_START_DATE

PRICE_BOOK_END_DATE

PRICE_VALID_FROM

PRICE_VALID_UNTIL

CURRENCY_CODE

SYSTEM_GENERATED_FLAG

BUSINESS_UNIT_ID

INVENTORY_ITEM_ID

INVENTORY_ORG_ID

INVENTORY_ITEM_NUMBER

COMPONENT_ID_PATH

COMPONENT_PATH

ITEM_TYPE_CODE

CATEGORY_CODE

PARENT_LINE_ID

ROOT_LINE_ID

ROOT_COVERAGE_LINE_ID

LINE_QUANTITY

LINE_QUANTITY_UOM_CODE

LINE_TYPE_CODE

APPLIED_PRICE_LIST_ID

APPLIED_SHIP_CHARGE_LIST_ID

RATE_PLAN_ID

REQUESTED_RATE_PLAN_ID

PRICED_ON

CUSTOMER_ID

BILL_TO_CUSTOMER_ID

BILL_TO_PARTY_ID

BILL_TO_PARTY_SITE_ID

BILL_TO_LOCATION_ID

BILL_FROM_LOCATION_ID

SHIP_FROM_LOCATION_ID

SHIP_TO_LOCATION_ID

SHIP_METHOD_ID

SHIP_FROM_PARTY_ID

SHIP_TO_PARTY_ID

PRICING_STRATEGY_ID

AGREEMENT_HEADER_ID

AGREEMENT_LINE_ID

AGREEMENT_VERSION_NUMBER

ADDITIONAL_ATTRS

ACTION_TYPE_CODE

SERVICE_DURATION

SERVICE_DURATION_PERIOD_CODE

SERVICE_START_DATE

SERVICE_DURATION_TYPE_CODE

ITEM_CATALOG_GROUP_ID

STYLE_ITEM_ID

STYLE_ITEM_FLAG

SERVICE_END_DATE

PRICE_BOOK_REQUEST_ID

BATCH_ID

CHILD_BATCH_ID

ESS_CHILD_PROCESS_ID

STATUS_CODE

SALES_PRODUCT_TYPE

CREATION_DATE

CREATED_BY

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

COVERED_ITEM_UOM_CODE

COVERAGE_DURATION_UOM_CODE

COVERAGE_DURATION

RATE_PLAN_NUMBER

PB_LINES_START_DATE

PB_LINES_END_DATE

Query

SQL_Statement
SELECT QP_PRICE_BOOK_LINES.PRICE_BOOK_LINE_ID PRICE_BOOK_LINE_ID, QP_PRICE_BOOK_LINES.PRICE_BOOK_ID PRICE_BOOK_ID, QP_PRICE_BOOK_LINES.PRICE_BOOK_START_DATE PRICE_BOOK_START_DATE, QP_PRICE_BOOK_LINES.PRICE_BOOK_END_DATE PRICE_BOOK_END_DATE, QP_PRICE_BOOK_LINES.PRICE_VALID_FROM PRICE_VALID_FROM, QP_PRICE_BOOK_LINES.PRICE_VALID_UNTIL PRICE_VALID_UNTIL, QP_PRICE_BOOK_LINES.CURRENCY_CODE CURRENCY_CODE, QP_PRICE_BOOK_LINES.SYSTEM_GENERATED_FLAG SYSTEM_GENERATED_FLAG, QP_PRICE_BOOK_LINES.BUSINESS_UNIT_ID BUSINESS_UNIT_ID, QP_PRICE_BOOK_LINES.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, QP_PRICE_BOOK_LINES.INVENTORY_ORG_ID INVENTORY_ORG_ID, QP_PRICE_BOOK_LINES.INVENTORY_ITEM_NUMBER INVENTORY_ITEM_NUMBER, QP_PRICE_BOOK_LINES.COMPONENT_ID_PATH COMPONENT_ID_PATH, QP_PRICE_BOOK_LINES.COMPONENT_PATH COMPONENT_PATH, QP_PRICE_BOOK_LINES.ITEM_TYPE_CODE ITEM_TYPE_CODE, QP_PRICE_BOOK_LINES.CATEGORY_CODE CATEGORY_CODE, QP_PRICE_BOOK_LINES.PARENT_LINE_ID PARENT_LINE_ID, QP_PRICE_BOOK_LINES.ROOT_LINE_ID ROOT_LINE_ID, QP_PRICE_BOOK_LINES.ROOT_COVERAGE_LINE_ID ROOT_COVERAGE_LINE_ID, QP_PRICE_BOOK_LINES.LINE_QUANTITY LINE_QUANTITY, QP_PRICE_BOOK_LINES.LINE_QUANTITY_UOM_CODE LINE_QUANTITY_UOM_CODE, QP_PRICE_BOOK_LINES.LINE_TYPE_CODE LINE_TYPE_CODE, QP_PRICE_BOOK_LINES.APPLIED_PRICE_LIST_ID APPLIED_PRICE_LIST_ID, QP_PRICE_BOOK_LINES.APPLIED_SHIP_CHARGE_LIST_ID APPLIED_SHIP_CHARGE_LIST_ID, QP_PRICE_BOOK_LINES.RATE_PLAN_ID RATE_PLAN_ID, QP_PRICE_BOOK_LINES.REQUESTED_RATE_PLAN_ID REQUESTED_RATE_PLAN_ID, QP_PRICE_BOOK_LINES.PRICED_ON PRICED_ON, QP_PRICE_BOOK_LINES.CUSTOMER_ID CUSTOMER_ID, QP_PRICE_BOOK_LINES.BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID, QP_PRICE_BOOK_LINES.BILL_TO_PARTY_ID BILL_TO_PARTY_ID, QP_PRICE_BOOK_LINES.BILL_TO_PARTY_SITE_ID BILL_TO_PARTY_SITE_ID, QP_PRICE_BOOK_LINES.BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID, QP_PRICE_BOOK_LINES.BILL_FROM_LOCATION_ID BILL_FROM_LOCATION_ID, QP_PRICE_BOOK_LINES.SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID, QP_PRICE_BOOK_LINES.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, QP_PRICE_BOOK_LINES.SHIP_METHOD_ID SHIP_METHOD_ID, QP_PRICE_BOOK_LINES.SHIP_FROM_PARTY_ID SHIP_FROM_PARTY_ID, QP_PRICE_BOOK_LINES.SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID, QP_PRICE_BOOK_LINES.PRICING_STRATEGY_ID PRICING_STRATEGY_ID, QP_PRICE_BOOK_LINES.AGREEMENT_HEADER_ID AGREEMENT_HEADER_ID, QP_PRICE_BOOK_LINES.AGREEMENT_LINE_ID AGREEMENT_LINE_ID, QP_PRICE_BOOK_LINES.AGREEMENT_VERSION_NUMBER AGREEMENT_VERSION_NUMBER, QP_PRICE_BOOK_LINES.ADDITIONAL_ATTRS ADDITIONAL_ATTRS, QP_PRICE_BOOK_LINES.ACTION_TYPE_CODE ACTION_TYPE_CODE, QP_PRICE_BOOK_LINES.SERVICE_DURATION SERVICE_DURATION, QP_PRICE_BOOK_LINES.SERVICE_DURATION_PERIOD_CODE SERVICE_DURATION_PERIOD_CODE, QP_PRICE_BOOK_LINES.SERVICE_START_DATE SERVICE_START_DATE, QP_PRICE_BOOK_LINES.SERVICE_DURATION_TYPE_CODE SERVICE_DURATION_TYPE_CODE, QP_PRICE_BOOK_LINES.ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID, QP_PRICE_BOOK_LINES.STYLE_ITEM_ID STYLE_ITEM_ID, QP_PRICE_BOOK_LINES.STYLE_ITEM_FLAG STYLE_ITEM_FLAG, QP_PRICE_BOOK_LINES.SERVICE_END_DATE SERVICE_END_DATE, QP_PRICE_BOOK_LINES.PRICE_BOOK_REQUEST_ID PRICE_BOOK_REQUEST_ID, QP_PRICE_BOOK_LINES.BATCH_ID BATCH_ID, QP_PRICE_BOOK_LINES.CHILD_BATCH_ID CHILD_BATCH_ID, QP_PRICE_BOOK_LINES.ESS_CHILD_PROCESS_ID ESS_CHILD_PROCESS_ID, QP_PRICE_BOOK_LINES.STATUS_CODE STATUS_CODE, QP_PRICE_BOOK_LINES.SALES_PRODUCT_TYPE SALES_PRODUCT_TYPE, QP_PRICE_BOOK_LINES.CREATION_DATE CREATION_DATE, QP_PRICE_BOOK_LINES.CREATED_BY CREATED_BY, QP_PRICE_BOOK_LINES.LAST_UPDATED_BY LAST_UPDATED_BY, QP_PRICE_BOOK_LINES.LAST_UPDATE_DATE LAST_UPDATE_DATE, QP_PRICE_BOOK_LINES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, QP_PRICE_BOOK_LINES.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, QP_PRICE_BOOK_LINES.COVERED_ITEM_UOM_CODE COVERED_ITEM_UOM_CODE, QP_PRICE_BOOK_LINES.COVERAGE_DURATION_UOM_CODE COVERAGE_DURATION_UOM_CODE, QP_PRICE_BOOK_LINES.COVERAGE_DURATION COVERAGE_DURATION, QP_PRICE_BOOK_LINES.RATE_PLAN_NUMBER RATE_PLAN_NUMBER, QP_PRICE_BOOK_REQUESTS.PB_LINES_START_DATE PB_LINES_START_DATE, QP_PRICE_BOOK_REQUESTS.PB_LINES_END_DATE PB_LINES_END_DATE FROM QP_PRICE_BOOK_LINES, QP_PRICE_BOOK_REQUESTS WHERE QP_PRICE_BOOK_LINES.PRICE_BOOK_ID = QP_PRICE_BOOK_REQUESTS.PRICE_BOOK_ID AND QP_PRICE_BOOK_LINES.PRICE_BOOK_REQUEST_ID = QP_PRICE_BOOK_REQUESTS.PRICE_BOOK_REQUEST_ID AND NVL(QP_PRICE_BOOK_LINES.SYSTEM_GENERATED_FLAG, 'N') = 'Y' AND QP_PRICE_BOOK_REQUESTS.PB_LINES_START_DATE IS NOT NULL AND SYSDATE BETWEEN QP_PRICE_BOOK_REQUESTS.PB_LINES_START_DATE AND NVL(QP_PRICE_BOOK_REQUESTS.PB_LINES_END_DATE, SYSDATE)

SQL_Statement

SELECT

QP_PRICE_BOOK_LINES.PRICE_BOOK_LINE_ID PRICE_BOOK_LINE_ID,

QP_PRICE_BOOK_LINES.PRICE_BOOK_ID PRICE_BOOK_ID,

QP_PRICE_BOOK_LINES.PRICE_BOOK_START_DATE PRICE_BOOK_START_DATE,

QP_PRICE_BOOK_LINES.PRICE_BOOK_END_DATE PRICE_BOOK_END_DATE,

QP_PRICE_BOOK_LINES.PRICE_VALID_FROM PRICE_VALID_FROM,

QP_PRICE_BOOK_LINES.PRICE_VALID_UNTIL PRICE_VALID_UNTIL,

QP_PRICE_BOOK_LINES.CURRENCY_CODE CURRENCY_CODE,

QP_PRICE_BOOK_LINES.SYSTEM_GENERATED_FLAG SYSTEM_GENERATED_FLAG,

QP_PRICE_BOOK_LINES.BUSINESS_UNIT_ID BUSINESS_UNIT_ID,

QP_PRICE_BOOK_LINES.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,

QP_PRICE_BOOK_LINES.INVENTORY_ORG_ID INVENTORY_ORG_ID,

QP_PRICE_BOOK_LINES.INVENTORY_ITEM_NUMBER INVENTORY_ITEM_NUMBER,

QP_PRICE_BOOK_LINES.COMPONENT_ID_PATH COMPONENT_ID_PATH,

QP_PRICE_BOOK_LINES.COMPONENT_PATH COMPONENT_PATH,

QP_PRICE_BOOK_LINES.ITEM_TYPE_CODE ITEM_TYPE_CODE,

QP_PRICE_BOOK_LINES.CATEGORY_CODE CATEGORY_CODE,

QP_PRICE_BOOK_LINES.PARENT_LINE_ID PARENT_LINE_ID,

QP_PRICE_BOOK_LINES.ROOT_LINE_ID ROOT_LINE_ID,

QP_PRICE_BOOK_LINES.ROOT_COVERAGE_LINE_ID ROOT_COVERAGE_LINE_ID,

QP_PRICE_BOOK_LINES.LINE_QUANTITY LINE_QUANTITY,

QP_PRICE_BOOK_LINES.LINE_QUANTITY_UOM_CODE LINE_QUANTITY_UOM_CODE,

QP_PRICE_BOOK_LINES.LINE_TYPE_CODE LINE_TYPE_CODE,

QP_PRICE_BOOK_LINES.APPLIED_PRICE_LIST_ID APPLIED_PRICE_LIST_ID,

QP_PRICE_BOOK_LINES.APPLIED_SHIP_CHARGE_LIST_ID APPLIED_SHIP_CHARGE_LIST_ID,

QP_PRICE_BOOK_LINES.RATE_PLAN_ID RATE_PLAN_ID,

QP_PRICE_BOOK_LINES.REQUESTED_RATE_PLAN_ID REQUESTED_RATE_PLAN_ID,

QP_PRICE_BOOK_LINES.PRICED_ON PRICED_ON,

QP_PRICE_BOOK_LINES.CUSTOMER_ID CUSTOMER_ID,

QP_PRICE_BOOK_LINES.BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID,

QP_PRICE_BOOK_LINES.BILL_TO_PARTY_ID BILL_TO_PARTY_ID,

QP_PRICE_BOOK_LINES.BILL_TO_PARTY_SITE_ID BILL_TO_PARTY_SITE_ID,

QP_PRICE_BOOK_LINES.BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID,

QP_PRICE_BOOK_LINES.BILL_FROM_LOCATION_ID BILL_FROM_LOCATION_ID,

QP_PRICE_BOOK_LINES.SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID,

QP_PRICE_BOOK_LINES.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID,

QP_PRICE_BOOK_LINES.SHIP_METHOD_ID SHIP_METHOD_ID,

QP_PRICE_BOOK_LINES.SHIP_FROM_PARTY_ID SHIP_FROM_PARTY_ID,

QP_PRICE_BOOK_LINES.SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID,

QP_PRICE_BOOK_LINES.PRICING_STRATEGY_ID PRICING_STRATEGY_ID,

QP_PRICE_BOOK_LINES.AGREEMENT_HEADER_ID AGREEMENT_HEADER_ID,

QP_PRICE_BOOK_LINES.AGREEMENT_LINE_ID AGREEMENT_LINE_ID,

QP_PRICE_BOOK_LINES.AGREEMENT_VERSION_NUMBER AGREEMENT_VERSION_NUMBER,

QP_PRICE_BOOK_LINES.ADDITIONAL_ATTRS ADDITIONAL_ATTRS,

QP_PRICE_BOOK_LINES.ACTION_TYPE_CODE ACTION_TYPE_CODE,

QP_PRICE_BOOK_LINES.SERVICE_DURATION SERVICE_DURATION,

QP_PRICE_BOOK_LINES.SERVICE_DURATION_PERIOD_CODE SERVICE_DURATION_PERIOD_CODE,

QP_PRICE_BOOK_LINES.SERVICE_START_DATE SERVICE_START_DATE,

QP_PRICE_BOOK_LINES.SERVICE_DURATION_TYPE_CODE SERVICE_DURATION_TYPE_CODE,

QP_PRICE_BOOK_LINES.ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID,

QP_PRICE_BOOK_LINES.STYLE_ITEM_ID STYLE_ITEM_ID,

QP_PRICE_BOOK_LINES.STYLE_ITEM_FLAG STYLE_ITEM_FLAG,

QP_PRICE_BOOK_LINES.SERVICE_END_DATE SERVICE_END_DATE,

QP_PRICE_BOOK_LINES.PRICE_BOOK_REQUEST_ID PRICE_BOOK_REQUEST_ID,

QP_PRICE_BOOK_LINES.BATCH_ID BATCH_ID,

QP_PRICE_BOOK_LINES.CHILD_BATCH_ID CHILD_BATCH_ID,

QP_PRICE_BOOK_LINES.ESS_CHILD_PROCESS_ID ESS_CHILD_PROCESS_ID,

QP_PRICE_BOOK_LINES.STATUS_CODE STATUS_CODE,

QP_PRICE_BOOK_LINES.SALES_PRODUCT_TYPE SALES_PRODUCT_TYPE,

QP_PRICE_BOOK_LINES.CREATION_DATE CREATION_DATE,

QP_PRICE_BOOK_LINES.CREATED_BY CREATED_BY,

QP_PRICE_BOOK_LINES.LAST_UPDATED_BY LAST_UPDATED_BY,

QP_PRICE_BOOK_LINES.LAST_UPDATE_DATE LAST_UPDATE_DATE,

QP_PRICE_BOOK_LINES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

QP_PRICE_BOOK_LINES.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

QP_PRICE_BOOK_LINES.COVERED_ITEM_UOM_CODE COVERED_ITEM_UOM_CODE,

QP_PRICE_BOOK_LINES.COVERAGE_DURATION_UOM_CODE COVERAGE_DURATION_UOM_CODE,

QP_PRICE_BOOK_LINES.COVERAGE_DURATION COVERAGE_DURATION,

QP_PRICE_BOOK_LINES.RATE_PLAN_NUMBER RATE_PLAN_NUMBER,

QP_PRICE_BOOK_REQUESTS.PB_LINES_START_DATE PB_LINES_START_DATE,

QP_PRICE_BOOK_REQUESTS.PB_LINES_END_DATE PB_LINES_END_DATE

FROM

QP_PRICE_BOOK_LINES,

QP_PRICE_BOOK_REQUESTS

WHERE

QP_PRICE_BOOK_LINES.PRICE_BOOK_ID = QP_PRICE_BOOK_REQUESTS.PRICE_BOOK_ID

AND QP_PRICE_BOOK_LINES.PRICE_BOOK_REQUEST_ID = QP_PRICE_BOOK_REQUESTS.PRICE_BOOK_REQUEST_ID

AND NVL(QP_PRICE_BOOK_LINES.SYSTEM_GENERATED_FLAG, 'N') = 'Y'

AND QP_PRICE_BOOK_REQUESTS.PB_LINES_START_DATE IS NOT NULL AND SYSDATE BETWEEN QP_PRICE_BOOK_REQUESTS.PB_LINES_START_DATE AND NVL(QP_PRICE_BOOK_REQUESTS.PB_LINES_END_DATE, SYSDATE)