View: SO_PICKING_RULES_V

View Text

SELECT SPR.ROWID ROW_ID
, SPR.PICKING_RULE
, SPR.CREATION_DATE
, SPR.CREATED_BY
, SPR.LAST_UPDATE_DATE
, SPR.LAST_UPDATED_BY
, SPR.LAST_UPDATE_LOGIN
, SPR.PROGRAM_APPLICATION_ID
, SPR.PROGRAM_ID
, SPR.PROGRAM_UPDATE_DATE
, SPR.REQUEST_ID
, SPR.BACKORDERS_ONLY_FLAG
, S1.MEANING BACKORDERS
, SPR.EXISTING_RSVS_ONLY_FLAG
, DECODE(SPR.EXISTING_RSVS_ONLY_FLAG
, 'Y'
, '*'
, NULL) RESERVATION_STAR
, S3.MEANING RESERVATION
, SPR.SHIPMENT_PRIORITY_CODE
, S2.MEANING SHIPMENT_PRIORITY
, SPR.SHIP_METHOD_CODE
, SPR.CUSTOMER_ID
, RC.CUSTOMER_NAME
, RC.CUSTOMER_NUMBER
, SPR.GROUP_ID
, SPR.HEADER_ID
, H.ORDER_NUMBER
, SPR.SHIP_SET_NUMBER
, SPR.INVENTORY_ITEM_ID
, SPR.ORDER_TYPE_ID
, OT.NAME ORDER_TYPE
, DECODE(SPR.DATE_REQUESTED_FROM
, TO_DATE('1'
, 'J')
, TRUNC(SYSDATE)
, SPR.DATE_REQUESTED_FROM) DATE_REQUESTED_FROM
, DECODE(SPR.DATE_REQUESTED_TO
, TO_DATE('1'
, 'J')
, TRUNC(SYSDATE)
, SPR.DATE_REQUESTED_TO) DATE_REQUESTED_TO
, DECODE(SPR.SCHEDULED_SHIPMENT_DATE_FROM
, TO_DATE('1'
, 'J')
, TRUNC(SYSDATE)
, SPR.SCHEDULED_SHIPMENT_DATE_FROM) SCHEDULED_SHIPMENT_DATE_FROM
, DECODE(SPR.SCHEDULED_SHIPMENT_DATE_TO
, TO_DATE('1'
, 'J')
, TRUNC(SYSDATE)
, SPR.SCHEDULED_SHIPMENT_DATE_TO) SCHEDULED_SHIPMENT_DATE_TO
, SPR.SITE_USE_ID
, SU.LOCATION
, SPR.WAREHOUSE_ID
, ORG.ORGANIZATION_CODE WAREHOUSE_CODE
, H_ORG_TL.NAME WAREHOUSE
, SPR.SUBINVENTORY
, SPR.PICK_SLIP_RULE_ID
, PSR.NAME PICK_SLIP_RULE_NAME
, SPR.RELEASE_SEQ_RULE_SET_ID RELEASE_SEQ_RULE_ID
, RSR.NAME RELEASE_SEQ_RULE_NAME
, SPR.PARTIAL_ALLOWED_FLAG
, SPR.INCLUDE_PLANNED_LINES_FLAG INCLUDE_PLANNED_LINES
, SPR.START_DATE_ACTIVE
, SPR.END_DATE_ACTIVE
, SPR.AUTOCREATE_DELIVERY_FLAG
FROM MTL_PARAMETERS ORG
, HR_ORG_UNITS_NO_JOIN H_ORG_NJ
, HR_ALL_ORGANIZATION_UNITS_TL H_ORG_TL
, RA_CUSTOMERS RC
, SO_LOOKUPS S1
, SO_LOOKUPS S2
, SO_LOOKUPS S3
, WSH_PICK_SLIP_RULES PSR
, WSH_RELEASE_SEQ_RULES RSR
, SO_ORDER_TYPES OT
, RA_SITE_USES SU
, SO_HEADERS H
, SO_PICKING_RULES SPR
WHERE RC.CUSTOMER_ID(+) = SPR.CUSTOMER_ID
AND ORG.ORGANIZATION_ID(+) = SPR.WAREHOUSE_ID
AND H_ORG_NJ.ORGANIZATION_ID(+) = SPR.WAREHOUSE_ID
AND H_ORG_TL.ORGANIZATION_ID(+) = SPR.WAREHOUSE_ID
AND H_ORG_TL.LANGUAGE(+) = USERENV('LANG')
AND PSR.PICK_SLIP_RULE_ID(+) = SPR.PICK_SLIP_RULE_ID
AND RSR.RELEASE_SEQ_RULE_ID(+) = SPR.RELEASE_SEQ_RULE_SET_ID
AND S1.LOOKUP_TYPE(+) = 'PICK_RELEASE_OPTIONS'
AND S1.LOOKUP_CODE(+) = SPR.BACKORDERS_ONLY_FLAG
AND S2.LOOKUP_TYPE(+) = 'SHIPMENT_PRIORITY'
AND S2.LOOKUP_CODE(+) = SPR.SHIPMENT_PRIORITY_CODE
AND OT.ORDER_TYPE_ID(+) = NVL(SPR.ORDER_TYPE_ID
, -1)
AND SU.SITE_USE_ID(+) = NVL(SPR.SITE_USE_ID
, -1)
AND H.HEADER_ID(+) = NVL(SPR.HEADER_ID
, -1)
AND S3.LOOKUP_TYPE(+) = 'YES_NO'
AND S3.LOOKUP_CODE(+) = SPR.EXISTING_RSVS_ONLY_FLAG

Columns