VIEW: APPS.WSHFV_PICK_SLIP_GROUPING_RULES

Source

View Text - Preformatted

SELECT WPGR.PICK_GROUPING_RULE_ID PICK_SLIP_GROUPING_RULE_ID ,WPGR.NAME ,WPGR.DESCRIPTION , '_LA:WPGR.ORDER_NUMBER_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_LA:WPGR.SUBINVENTORY_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_LA:WPGR.CUSTOMER_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_LA:WPGR.SHIP_TO_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_LA:WPGR.CARRIER_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_LA:WPGR.SHIPMENT_PRIORITY_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_LA:WPGR.TRIP_STOP_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_LA:WPGR.DELIVERY_FLAG:FND_LOOKUPS:YES_NO:MEANING', WPGR.START_DATE_ACTIVE , WPGR.END_DATE_ACTIVE ,WPGR.PICK_METHOD,WPGR.ITEM_FLAG,WPGR.LOCATOR_FLAG, WPGR.LOT_FLAG,WPGR.REVISION_FLAG, WPGR.CREATION_DATE , WPGR.CREATED_BY , WPGR.LAST_UPDATE_DATE , WPGR.LAST_UPDATED_BY , '_DF:WSH:WSH_PICK_GROUPING_RULES:WPGR' FROM WSH_PICK_GROUPING_RULES WPGR with read only

View Text - HTML Formatted

SELECT WPGR.PICK_GROUPING_RULE_ID PICK_SLIP_GROUPING_RULE_ID
, WPGR.NAME
, WPGR.DESCRIPTION
, '_LA:WPGR.ORDER_NUMBER_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:WPGR.SUBINVENTORY_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:WPGR.CUSTOMER_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:WPGR.SHIP_TO_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:WPGR.CARRIER_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:WPGR.SHIPMENT_PRIORITY_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:WPGR.TRIP_STOP_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:WPGR.DELIVERY_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WPGR.START_DATE_ACTIVE
, WPGR.END_DATE_ACTIVE
, WPGR.PICK_METHOD
, WPGR.ITEM_FLAG
, WPGR.LOCATOR_FLAG
, WPGR.LOT_FLAG
, WPGR.REVISION_FLAG
, WPGR.CREATION_DATE
, WPGR.CREATED_BY
, WPGR.LAST_UPDATE_DATE
, WPGR.LAST_UPDATED_BY
, '_DF:WSH:WSH_PICK_GROUPING_RULES:WPGR'
FROM WSH_PICK_GROUPING_RULES WPGR WITH READ ONLY