VIEW: APPS.MSC_SUP_DEM_ENTRIES_UI_V

Source

View Text - Preformatted

SELECT supdem.TRANSACTION_ID TRANSACTION_ID, supdem.PLAN_ID PLAN_ID, supdem.SR_INSTANCE_ID SR_INSTANCE_ID, supdem.PUBLISHER_ID PUBLISHER_ID, supdem.PUBLISHER_SITE_ID PUBLISHER_SITE_ID, supdem.PUBLISHER_NAME PUBLISHER_NAME, supdem.PUBLISHER_SITE_NAME PUBLISHER_SITE_NAME, supdem.NEW_SCHEDULE_DATE NEW_SCHEDULE_DATE, supdem.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, supdem.QUANTITY QUANTITY, supdem.TP_QUANTITY TP_QUANTITY, supdem.COMMENTS COMMENTS, supdem.PUBLISHER_ORDER_TYPE PUBLISHER_ORDER_TYPE, supdem.SUPPLIER_ID SUPPLIER_ID, supdem.SUPPLIER_NAME SUPPLIER_NAME, supdem.SUPPLIER_SITE_ID SUPPLIER_SITE_ID, supdem.SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME, supdem.CUSTOMER_ID CUSTOMER_ID, supdem.CUSTOMER_NAME CUSTOMER_NAME, supdem.CUSTOMER_SITE_ID CUSTOMER_SITE_ID, supdem.CUSTOMER_SITE_NAME CUSTOMER_SITE_NAME, supdem.LINE_CODE LINE_CODE, supdem.BUCKET_TYPE BUCKET_TYPE, supdem.ORDER_NUMBER ORDER_NUMBER, supdem.END_ORDER_NUMBER END_ORDER_NUMBER, supdem.NEW_DOCK_DATE NEW_DOCK_DATE, supdem.POSTING_PARTY_ID POSTING_PARTY_ID, supdem.NEW_SHIP_DATE NEW_SHIP_DATE, supdem.NEW_ORDER_PLACEMENT_DATE NEW_ORDER_PLACEMENT_DATE, supdem.RELEASE_NUMBER RELEASE_NUMBER, supdem.LINE_NUMBER LINE_NUMBER, supdem.END_ORDER_REL_NUMBER END_ORDER_REL_NUMBER, supdem.END_ORDER_LINE_NUMBER END_ORDER_LINE_NUMBER, supdem.PUBLISHER_ADDRESS_ID PUBLISHER_ADDRESS_ID, supdem.CARRIER_CODE CARRIER_CODE, supdem.VEHICLE_NUMBER VEHICLE_NUMBER, supdem.CONTAINER_TYPE CONTAINER_TYPE, supdem.CONTAINER_QTY CONTAINER_QTY, supdem.TRACKING_NUMBER TRACKING_NUMBER, supdem.VERSION VERSION, supdem.END_ORDER_TYPE END_ORDER_TYPE, supdem.END_ORDER_PUBLISHER_ID END_ORDER_PUBLISHER_ID, supdem.SHIP_TO_ADDRESS SHIP_TO_ADDRESS, supdem.SHIP_FROM_PARTY_ID SHIP_FROM_PARTY_ID, supdem.SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID, supdem.SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_SITE_ID, supdem.SHIP_TO_PARTY_ADDRESS_ID SHIP_TO_PARTY_ADDRESS_ID, supdem.SHIP_TO_PARTY_NAME SHIP_TO_PARTY_NAME, supdem.SHIP_TO_PARTY_SITE_NAME SHIP_TO_PARTY_SITE_NAME, supdem.SHIP_FROM_PARTY_ADDRESS_ID SHIP_FROM_PARTY_ADDRESS_ID, supdem.SHIP_FROM_PARTY_SITE_ID SHIP_FROM_PARTY_SITE_ID, supdem.SHIP_FROM_PARTY_NAME SHIP_FROM_PARTY_NAME, supdem.SHIP_FROM_PARTY_SITE_NAME SHIP_FROM_PARTY_SITE_NAME, supdem.OWNING_SITE_ID OWNING_SITE_ID, supdem.OWNING_SITE_NAME OWNING_SITE_NAME, supdem.END_ORDER_PUBLISHER_SITE_ID END_ORDER_PUBLISHER_SITE_ID, supdem.END_ORDER_PUBLISHER_SITE_NAME END_ORDER_PUBLISHER_SITE_NAME, supdem.END_ORDER_PUBLISHER_NAME END_ORDER_PUBLISHER_NAME, supdem.ITEM_NAME ITEM_NAME, supdem.OWNER_ITEM_NAME OWNER_ITEM_NAME, supdem.CUSTOMER_ITEM_NAME CUSTOMER_ITEM_NAME, supdem.SUPPLIER_ITEM_NAME SUPPLIER_ITEM_NAME, supdem.ITEM_DESCRIPTION ITEM_DESCRIPTION , supdem.CUSTOMER_ITEM_DESCRIPTION CUSTOMER_ITEM_DESCRIPTION, supdem.SUPPLIER_ITEM_DESCRIPTION SUPPLIER_ITEM_DESCRIPTION, supdem.OWNER_ITEM_DESCRIPTION OWNER_ITEM_DESCRIPTION, look.meaning PUBLISHER_ORDER_TYPE_DESC, supdem.DESIGNATOR DESIGNATOR, supdem.CONTEXT CONTEXT, supdem.UNIT_NUMBER UNIT_NUMBER, supdem.SHIP_METHOD SHIP_METHOD, supdem.PROJECT_NUMBER PROJECT_NUMBER, supdem.TASK_NUMBER TASK_NUMBER, supdem.PLANNING_GROUP PLANNING_GROUP, supdem.SHIP_FROM_ADDRESS SHIP_FROM_ADDRESS, supdem.PUBLISHER_ADDRESS PUBLISHER_ADDRESS, supdem.CUSTOMER_ADDRESS CUSTOMER_ADDRESS, supdem.SUPPLIER_ADDRESS SUPPLIER_ADDRESS, supdem.AVERAGE_ANNUAL_DEMAND AVERAGE_ANNUAL_DEMAND, supdem.BILL_OF_LADING_NUMBER BILL_OF_LADING_NUMBER, supdem.BUCKET_TYPE_DESC BUCKET_TYPE_DESC, supdem.SERIAL_NUMBER SERIAL_NUMBER, supdem.RELEASE_STATUS RELEASE_STATUS, supdem.INVENTORY_STATUS INVENTORY_STATUS, supdem.WIP_END_DATE WIP_END_DATE, supdem.WIP_START_DATE WIP_START_DATE, supdem.PROMISE_SHIP_DATE PROMISE_SHIP_DATE, supdem.NEW_SCHEDULE_END_DATE NEW_SCHEDULE_END_DATE, supdem.POSTING_PARTY_NAME POSTING_PARTY_NAME, supdem.UOM_CODE UOM_CODE, supdem.TP_UOM_CODE TP_UOM_CODE, supdem.PLANNER_CODE PLANNER_CODE, supdem.LAST_REFRESH_NUMBER LAST_REFRESH_NUMBER, supdem.ATTACHMENT_URL ATTACHMENT_URL, supdem.ATTRIBUTE1 ATTRIBUTE1, supdem.ATTRIBUTE2 ATTRIBUTE2, supdem.ATTRIBUTE3 ATTRIBUTE3, supdem.ATTRIBUTE4 ATTRIBUTE4, supdem.ATTRIBUTE5 ATTRIBUTE5, supdem.ATTRIBUTE6 ATTRIBUTE6, supdem.ATTRIBUTE7 ATTRIBUTE7, supdem.ATTRIBUTE8 ATTRIBUTE8, supdem.ATTRIBUTE9 ATTRIBUTE9, supdem.ATTRIBUTE10 ATTRIBUTE10, supdem.ATTRIBUTE11 ATTRIBUTE11, supdem.ATTRIBUTE12 ATTRIBUTE12, supdem.ATTRIBUTE13 ATTRIBUTE13, supdem.ATTRIBUTE14 ATTRIBUTE14, supdem.ATTRIBUTE15 ATTRIBUTE15, supdem.REQUEST_ID REQUEST_ID, supdem.PROGRAM_ID PROGRAM_ID, supdem.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, supdem.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, supdem.CREATED_BY CREATED_BY, supdem.CREATION_DATE CREATION_DATE, supdem.LAST_UPDATED_BY LAST_UPDATED_BY, supdem.LAST_UPDATE_DATE LAST_UPDATE_DATE, supdem.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, supdem.KEY_DATE KEY_DATE, supdem.SHIP_DATE SHIP_DATE, supdem.RECEIPT_DATE RECEIPT_DATE, supdem.ORIGINAL_PROMISED_DATE ORIGINAL_PROMISED_DATE, supdem.REQUEST_DATE REQUEST_DATE, supdem.PRIMARY_UOM PRIMARY_UOM, supdem.PRIMARY_QUANTITY PRIMARY_QUANTITY, supdem.REF_HEADER_ID REF_HEADER_ID, supdem.REF_LINE_ID REF_LINE_ID, supdem.PUBLISHER_ORG_ID PUBLISHER_ORG_ID, supdem.SUBSCRIBER_ORG_ID SUBSCRIBER_ORG_ID, supdem.ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID, supdem.CATEGORY_ID CATEGORY_ID, supdem.START_DATE START_DATE, supdem.END_DATE END_DATE, supdem.PRODUCTION_SEQUENCE PRODUCTION_SEQUENCE, supdem.SEQ_PLAN_COMPLETION_FLAG SEQ_PLAN_COMPLETION_FLAG, supdem.INPUT_PLAN_ID INPUT_PLAN_ID, supdem.END_ASSEMBLY_ITEM_NAME END_ASSEMBLY_ITEM_NAME, supdem.SUBSCRIBER_ADDRESS_ID SUBSCRIBER_ADDRESS_ID, supdem.TP_ORDER_TYPE TP_ORDER_TYPE, supdem.PROCESSED_FLAG PROCESSED_FLAG, null privilege , decode(sys_context('MSC','COMPANY_ID'), supdem.customer_id, supdem.customer_name, supdem.supplier_id, supdem.supplier_name, supdem.publisher_name) viewer_company , decode(sys_context('MSC','COMPANY_ID'), supdem.customer_id, supdem.customer_site_name, supdem.supplier_id, supdem.supplier_site_name, supdem.publisher_site_name) viewer_site, decode(sys_context('MSC','COMPANY_ID'), supdem.customer_id, supdem.supplier_name, supdem.supplier_id, supdem.customer_name, decode(supdem.publisher_id, supdem.customer_id, supdem.supplier_name, supdem.customer_name)) tp_company , decode(sys_context('MSC','COMPANY_ID'), supdem.supplier_id, supdem.customer_site_name,supdem.customer_id, supdem.supplier_site_name, decode(supdem.publisher_id, supdem.customer_id, supdem.supplier_site_name, supdem.customer_site_name)) tp_site , decode(sys_context('MSC','COMPANY_ID'), supdem.supplier_id, 1, supdem.customer_id, 1, 0) third_party_flag , supdem.base_item_id base_item_id, supdem.base_item_name base_item_name, supdem.shipping_control shipping_control, msc_x_util.get_buyer_code(inventory_item_id, publisher_id, publisher_site_id, supdem.customer_id, supdem.customer_site_id, supdem.supplier_id, supdem.supplier_site_id) BUYER_NAME , msc_x_util.get_category_code(inventory_item_id, publisher_id, publisher_site_id, supdem.customer_id, supdem.customer_site_id, supdem.supplier_id, supdem.supplier_site_id) CATEGORY_NAME, supdem.end_order_type_desc end_order_type_desc from msc_sup_dem_entries supdem, mfg_lookups look WHERE look.LOOKUP_TYPE ='MSC_X_ORDER_TYPE' and look.LOOKUP_CODE=PUBLISHER_ORDER_TYPE and exists (select 1 from MSC_X_SECURITY_RULES rule where sysdate between nvl(rule.EFFECTIVE_FROM_DATE, sysdate-1) and nvl(rule.EFFECTIVE_TO_DATE, sysdate +1) and nvl(rule.company_id, supdem.PUBLISHER_ID) = supdem.publisher_id and nvl(rule.order_type, supdem.publisher_order_type) = supdem.publisher_order_type and nvl(rule.item_id, supdem.inventory_item_id) = supdem.inventory_item_id and nvl(rule.customer_id, nvl(supdem.customer_id, -1)) = nvl(supdem.customer_id, -1) and nvl(rule.supplier_id, nvl(supdem.supplier_id, -1)) = nvl(supdem.supplier_id, -1) and nvl(rule.customer_site_id, nvl(supdem.customer_site_id,-1)) = nvl(supdem.customer_site_id, -1) and nvl(rule.supplier_site_id, nvl(supdem.supplier_site_id, -1)) = nvl(supdem.supplier_site_id, -1) and nvl(rule.org_id, supdem.PUBLISHER_SITE_ID) = supdem.PUBLISHER_SITE_ID and nvl(rule.order_number, nvl(supdem.order_number, -1)) = nvl(supdem.order_number, -1) and (rule.grantee_key = decode(upper(rule.grantee_type), 'USER', FND_GLOBAL.USER_ID, 'COMPANY', sys_context('MSC', 'COMPANY_ID')) or upper(rule.grantee_type) = 'DOCUMENT OWNER'and supdem.publisher_id = sys_context('MSC', 'COMPANY_ID') or upper(rule.grantee_type) = 'TRADING PARTNER' and supdem.customer_id = sys_context('MSC', 'COMPANY_ID') or upper(rule.grantee_type) = 'TRADING PARTNER' and supdem.supplier_id = sys_context('MSC', 'COMPANY_ID') or decode(upper(rule.grantee_type),'RESPONSIBILITY', rule.grantee_key) = fnd_global.resp_id or (upper(rule.grantee_type) = 'GLOBAL') or (upper(rule.grantee_type) = 'GROUP' and rule.grantee_key in (SELECT group_id FROM msc_group_companies WHERE company_id = sys_context('MSC' ,'COMPANY_ID') AND sysdate BETWEEN effective_date and nvl(disable_date ,sysdate+1) ) ) ))

View Text - HTML Formatted

SELECT SUPDEM.TRANSACTION_ID TRANSACTION_ID
, SUPDEM.PLAN_ID PLAN_ID
, SUPDEM.SR_INSTANCE_ID SR_INSTANCE_ID
, SUPDEM.PUBLISHER_ID PUBLISHER_ID
, SUPDEM.PUBLISHER_SITE_ID PUBLISHER_SITE_ID
, SUPDEM.PUBLISHER_NAME PUBLISHER_NAME
, SUPDEM.PUBLISHER_SITE_NAME PUBLISHER_SITE_NAME
, SUPDEM.NEW_SCHEDULE_DATE NEW_SCHEDULE_DATE
, SUPDEM.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SUPDEM.QUANTITY QUANTITY
, SUPDEM.TP_QUANTITY TP_QUANTITY
, SUPDEM.COMMENTS COMMENTS
, SUPDEM.PUBLISHER_ORDER_TYPE PUBLISHER_ORDER_TYPE
, SUPDEM.SUPPLIER_ID SUPPLIER_ID
, SUPDEM.SUPPLIER_NAME SUPPLIER_NAME
, SUPDEM.SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, SUPDEM.SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME
, SUPDEM.CUSTOMER_ID CUSTOMER_ID
, SUPDEM.CUSTOMER_NAME CUSTOMER_NAME
, SUPDEM.CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, SUPDEM.CUSTOMER_SITE_NAME CUSTOMER_SITE_NAME
, SUPDEM.LINE_CODE LINE_CODE
, SUPDEM.BUCKET_TYPE BUCKET_TYPE
, SUPDEM.ORDER_NUMBER ORDER_NUMBER
, SUPDEM.END_ORDER_NUMBER END_ORDER_NUMBER
, SUPDEM.NEW_DOCK_DATE NEW_DOCK_DATE
, SUPDEM.POSTING_PARTY_ID POSTING_PARTY_ID
, SUPDEM.NEW_SHIP_DATE NEW_SHIP_DATE
, SUPDEM.NEW_ORDER_PLACEMENT_DATE NEW_ORDER_PLACEMENT_DATE
, SUPDEM.RELEASE_NUMBER RELEASE_NUMBER
, SUPDEM.LINE_NUMBER LINE_NUMBER
, SUPDEM.END_ORDER_REL_NUMBER END_ORDER_REL_NUMBER
, SUPDEM.END_ORDER_LINE_NUMBER END_ORDER_LINE_NUMBER
, SUPDEM.PUBLISHER_ADDRESS_ID PUBLISHER_ADDRESS_ID
, SUPDEM.CARRIER_CODE CARRIER_CODE
, SUPDEM.VEHICLE_NUMBER VEHICLE_NUMBER
, SUPDEM.CONTAINER_TYPE CONTAINER_TYPE
, SUPDEM.CONTAINER_QTY CONTAINER_QTY
, SUPDEM.TRACKING_NUMBER TRACKING_NUMBER
, SUPDEM.VERSION VERSION
, SUPDEM.END_ORDER_TYPE END_ORDER_TYPE
, SUPDEM.END_ORDER_PUBLISHER_ID END_ORDER_PUBLISHER_ID
, SUPDEM.SHIP_TO_ADDRESS SHIP_TO_ADDRESS
, SUPDEM.SHIP_FROM_PARTY_ID SHIP_FROM_PARTY_ID
, SUPDEM.SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID
, SUPDEM.SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_SITE_ID
, SUPDEM.SHIP_TO_PARTY_ADDRESS_ID SHIP_TO_PARTY_ADDRESS_ID
, SUPDEM.SHIP_TO_PARTY_NAME SHIP_TO_PARTY_NAME
, SUPDEM.SHIP_TO_PARTY_SITE_NAME SHIP_TO_PARTY_SITE_NAME
, SUPDEM.SHIP_FROM_PARTY_ADDRESS_ID SHIP_FROM_PARTY_ADDRESS_ID
, SUPDEM.SHIP_FROM_PARTY_SITE_ID SHIP_FROM_PARTY_SITE_ID
, SUPDEM.SHIP_FROM_PARTY_NAME SHIP_FROM_PARTY_NAME
, SUPDEM.SHIP_FROM_PARTY_SITE_NAME SHIP_FROM_PARTY_SITE_NAME
, SUPDEM.OWNING_SITE_ID OWNING_SITE_ID
, SUPDEM.OWNING_SITE_NAME OWNING_SITE_NAME
, SUPDEM.END_ORDER_PUBLISHER_SITE_ID END_ORDER_PUBLISHER_SITE_ID
, SUPDEM.END_ORDER_PUBLISHER_SITE_NAME END_ORDER_PUBLISHER_SITE_NAME
, SUPDEM.END_ORDER_PUBLISHER_NAME END_ORDER_PUBLISHER_NAME
, SUPDEM.ITEM_NAME ITEM_NAME
, SUPDEM.OWNER_ITEM_NAME OWNER_ITEM_NAME
, SUPDEM.CUSTOMER_ITEM_NAME CUSTOMER_ITEM_NAME
, SUPDEM.SUPPLIER_ITEM_NAME SUPPLIER_ITEM_NAME
, SUPDEM.ITEM_DESCRIPTION ITEM_DESCRIPTION
, SUPDEM.CUSTOMER_ITEM_DESCRIPTION CUSTOMER_ITEM_DESCRIPTION
, SUPDEM.SUPPLIER_ITEM_DESCRIPTION SUPPLIER_ITEM_DESCRIPTION
, SUPDEM.OWNER_ITEM_DESCRIPTION OWNER_ITEM_DESCRIPTION
, LOOK.MEANING PUBLISHER_ORDER_TYPE_DESC
, SUPDEM.DESIGNATOR DESIGNATOR
, SUPDEM.CONTEXT CONTEXT
, SUPDEM.UNIT_NUMBER UNIT_NUMBER
, SUPDEM.SHIP_METHOD SHIP_METHOD
, SUPDEM.PROJECT_NUMBER PROJECT_NUMBER
, SUPDEM.TASK_NUMBER TASK_NUMBER
, SUPDEM.PLANNING_GROUP PLANNING_GROUP
, SUPDEM.SHIP_FROM_ADDRESS SHIP_FROM_ADDRESS
, SUPDEM.PUBLISHER_ADDRESS PUBLISHER_ADDRESS
, SUPDEM.CUSTOMER_ADDRESS CUSTOMER_ADDRESS
, SUPDEM.SUPPLIER_ADDRESS SUPPLIER_ADDRESS
, SUPDEM.AVERAGE_ANNUAL_DEMAND AVERAGE_ANNUAL_DEMAND
, SUPDEM.BILL_OF_LADING_NUMBER BILL_OF_LADING_NUMBER
, SUPDEM.BUCKET_TYPE_DESC BUCKET_TYPE_DESC
, SUPDEM.SERIAL_NUMBER SERIAL_NUMBER
, SUPDEM.RELEASE_STATUS RELEASE_STATUS
, SUPDEM.INVENTORY_STATUS INVENTORY_STATUS
, SUPDEM.WIP_END_DATE WIP_END_DATE
, SUPDEM.WIP_START_DATE WIP_START_DATE
, SUPDEM.PROMISE_SHIP_DATE PROMISE_SHIP_DATE
, SUPDEM.NEW_SCHEDULE_END_DATE NEW_SCHEDULE_END_DATE
, SUPDEM.POSTING_PARTY_NAME POSTING_PARTY_NAME
, SUPDEM.UOM_CODE UOM_CODE
, SUPDEM.TP_UOM_CODE TP_UOM_CODE
, SUPDEM.PLANNER_CODE PLANNER_CODE
, SUPDEM.LAST_REFRESH_NUMBER LAST_REFRESH_NUMBER
, SUPDEM.ATTACHMENT_URL ATTACHMENT_URL
, SUPDEM.ATTRIBUTE1 ATTRIBUTE1
, SUPDEM.ATTRIBUTE2 ATTRIBUTE2
, SUPDEM.ATTRIBUTE3 ATTRIBUTE3
, SUPDEM.ATTRIBUTE4 ATTRIBUTE4
, SUPDEM.ATTRIBUTE5 ATTRIBUTE5
, SUPDEM.ATTRIBUTE6 ATTRIBUTE6
, SUPDEM.ATTRIBUTE7 ATTRIBUTE7
, SUPDEM.ATTRIBUTE8 ATTRIBUTE8
, SUPDEM.ATTRIBUTE9 ATTRIBUTE9
, SUPDEM.ATTRIBUTE10 ATTRIBUTE10
, SUPDEM.ATTRIBUTE11 ATTRIBUTE11
, SUPDEM.ATTRIBUTE12 ATTRIBUTE12
, SUPDEM.ATTRIBUTE13 ATTRIBUTE13
, SUPDEM.ATTRIBUTE14 ATTRIBUTE14
, SUPDEM.ATTRIBUTE15 ATTRIBUTE15
, SUPDEM.REQUEST_ID REQUEST_ID
, SUPDEM.PROGRAM_ID PROGRAM_ID
, SUPDEM.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, SUPDEM.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SUPDEM.CREATED_BY CREATED_BY
, SUPDEM.CREATION_DATE CREATION_DATE
, SUPDEM.LAST_UPDATED_BY LAST_UPDATED_BY
, SUPDEM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SUPDEM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SUPDEM.KEY_DATE KEY_DATE
, SUPDEM.SHIP_DATE SHIP_DATE
, SUPDEM.RECEIPT_DATE RECEIPT_DATE
, SUPDEM.ORIGINAL_PROMISED_DATE ORIGINAL_PROMISED_DATE
, SUPDEM.REQUEST_DATE REQUEST_DATE
, SUPDEM.PRIMARY_UOM PRIMARY_UOM
, SUPDEM.PRIMARY_QUANTITY PRIMARY_QUANTITY
, SUPDEM.REF_HEADER_ID REF_HEADER_ID
, SUPDEM.REF_LINE_ID REF_LINE_ID
, SUPDEM.PUBLISHER_ORG_ID PUBLISHER_ORG_ID
, SUPDEM.SUBSCRIBER_ORG_ID SUBSCRIBER_ORG_ID
, SUPDEM.ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID
, SUPDEM.CATEGORY_ID CATEGORY_ID
, SUPDEM.START_DATE START_DATE
, SUPDEM.END_DATE END_DATE
, SUPDEM.PRODUCTION_SEQUENCE PRODUCTION_SEQUENCE
, SUPDEM.SEQ_PLAN_COMPLETION_FLAG SEQ_PLAN_COMPLETION_FLAG
, SUPDEM.INPUT_PLAN_ID INPUT_PLAN_ID
, SUPDEM.END_ASSEMBLY_ITEM_NAME END_ASSEMBLY_ITEM_NAME
, SUPDEM.SUBSCRIBER_ADDRESS_ID SUBSCRIBER_ADDRESS_ID
, SUPDEM.TP_ORDER_TYPE TP_ORDER_TYPE
, SUPDEM.PROCESSED_FLAG PROCESSED_FLAG
, NULL PRIVILEGE
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, SUPDEM.CUSTOMER_ID
, SUPDEM.CUSTOMER_NAME
, SUPDEM.SUPPLIER_ID
, SUPDEM.SUPPLIER_NAME
, SUPDEM.PUBLISHER_NAME) VIEWER_COMPANY
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, SUPDEM.CUSTOMER_ID
, SUPDEM.CUSTOMER_SITE_NAME
, SUPDEM.SUPPLIER_ID
, SUPDEM.SUPPLIER_SITE_NAME
, SUPDEM.PUBLISHER_SITE_NAME) VIEWER_SITE
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, SUPDEM.CUSTOMER_ID
, SUPDEM.SUPPLIER_NAME
, SUPDEM.SUPPLIER_ID
, SUPDEM.CUSTOMER_NAME
, DECODE(SUPDEM.PUBLISHER_ID
, SUPDEM.CUSTOMER_ID
, SUPDEM.SUPPLIER_NAME
, SUPDEM.CUSTOMER_NAME)) TP_COMPANY
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, SUPDEM.SUPPLIER_ID
, SUPDEM.CUSTOMER_SITE_NAME
, SUPDEM.CUSTOMER_ID
, SUPDEM.SUPPLIER_SITE_NAME
, DECODE(SUPDEM.PUBLISHER_ID
, SUPDEM.CUSTOMER_ID
, SUPDEM.SUPPLIER_SITE_NAME
, SUPDEM.CUSTOMER_SITE_NAME)) TP_SITE
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, SUPDEM.SUPPLIER_ID
, 1
, SUPDEM.CUSTOMER_ID
, 1
, 0) THIRD_PARTY_FLAG
, SUPDEM.BASE_ITEM_ID BASE_ITEM_ID
, SUPDEM.BASE_ITEM_NAME BASE_ITEM_NAME
, SUPDEM.SHIPPING_CONTROL SHIPPING_CONTROL
, MSC_X_UTIL.GET_BUYER_CODE(INVENTORY_ITEM_ID
, PUBLISHER_ID
, PUBLISHER_SITE_ID
, SUPDEM.CUSTOMER_ID
, SUPDEM.CUSTOMER_SITE_ID
, SUPDEM.SUPPLIER_ID
, SUPDEM.SUPPLIER_SITE_ID) BUYER_NAME
, MSC_X_UTIL.GET_CATEGORY_CODE(INVENTORY_ITEM_ID
, PUBLISHER_ID
, PUBLISHER_SITE_ID
, SUPDEM.CUSTOMER_ID
, SUPDEM.CUSTOMER_SITE_ID
, SUPDEM.SUPPLIER_ID
, SUPDEM.SUPPLIER_SITE_ID) CATEGORY_NAME
, SUPDEM.END_ORDER_TYPE_DESC END_ORDER_TYPE_DESC
FROM MSC_SUP_DEM_ENTRIES SUPDEM
, MFG_LOOKUPS LOOK
WHERE LOOK.LOOKUP_TYPE ='MSC_X_ORDER_TYPE'
AND LOOK.LOOKUP_CODE=PUBLISHER_ORDER_TYPE
AND EXISTS (SELECT 1
FROM MSC_X_SECURITY_RULES RULE
WHERE SYSDATE BETWEEN NVL(RULE.EFFECTIVE_FROM_DATE
, SYSDATE-1)
AND NVL(RULE.EFFECTIVE_TO_DATE
, SYSDATE +1)
AND NVL(RULE.COMPANY_ID
, SUPDEM.PUBLISHER_ID) = SUPDEM.PUBLISHER_ID
AND NVL(RULE.ORDER_TYPE
, SUPDEM.PUBLISHER_ORDER_TYPE) = SUPDEM.PUBLISHER_ORDER_TYPE
AND NVL(RULE.ITEM_ID
, SUPDEM.INVENTORY_ITEM_ID) = SUPDEM.INVENTORY_ITEM_ID
AND NVL(RULE.CUSTOMER_ID
, NVL(SUPDEM.CUSTOMER_ID
, -1)) = NVL(SUPDEM.CUSTOMER_ID
, -1)
AND NVL(RULE.SUPPLIER_ID
, NVL(SUPDEM.SUPPLIER_ID
, -1)) = NVL(SUPDEM.SUPPLIER_ID
, -1)
AND NVL(RULE.CUSTOMER_SITE_ID
, NVL(SUPDEM.CUSTOMER_SITE_ID
, -1)) = NVL(SUPDEM.CUSTOMER_SITE_ID
, -1)
AND NVL(RULE.SUPPLIER_SITE_ID
, NVL(SUPDEM.SUPPLIER_SITE_ID
, -1)) = NVL(SUPDEM.SUPPLIER_SITE_ID
, -1)
AND NVL(RULE.ORG_ID
, SUPDEM.PUBLISHER_SITE_ID) = SUPDEM.PUBLISHER_SITE_ID
AND NVL(RULE.ORDER_NUMBER
, NVL(SUPDEM.ORDER_NUMBER
, -1)) = NVL(SUPDEM.ORDER_NUMBER
, -1)
AND (RULE.GRANTEE_KEY = DECODE(UPPER(RULE.GRANTEE_TYPE)
, 'USER'
, FND_GLOBAL.USER_ID
, 'COMPANY'
, SYS_CONTEXT('MSC'
, 'COMPANY_ID')) OR UPPER(RULE.GRANTEE_TYPE) = 'DOCUMENT OWNER'AND SUPDEM.PUBLISHER_ID = SYS_CONTEXT('MSC'
, 'COMPANY_ID') OR UPPER(RULE.GRANTEE_TYPE) = 'TRADING PARTNER'
AND SUPDEM.CUSTOMER_ID = SYS_CONTEXT('MSC'
, 'COMPANY_ID') OR UPPER(RULE.GRANTEE_TYPE) = 'TRADING PARTNER'
AND SUPDEM.SUPPLIER_ID = SYS_CONTEXT('MSC'
, 'COMPANY_ID') OR DECODE(UPPER(RULE.GRANTEE_TYPE)
, 'RESPONSIBILITY'
, RULE.GRANTEE_KEY) = FND_GLOBAL.RESP_ID OR (UPPER(RULE.GRANTEE_TYPE) = 'GLOBAL') OR (UPPER(RULE.GRANTEE_TYPE) = 'GROUP'
AND RULE.GRANTEE_KEY IN (SELECT GROUP_ID
FROM MSC_GROUP_COMPANIES
WHERE COMPANY_ID = SYS_CONTEXT('MSC'
, 'COMPANY_ID')
AND SYSDATE BETWEEN EFFECTIVE_DATE
AND NVL(DISABLE_DATE
, SYSDATE+1) ) ) ))