Product: | RLM - Release Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.RLM_CUSTOMER_TERMS_V |
SELECT ORGDEF.ORGANIZATION_NAME
, ORGDEF.ORGANIZATION_CODE
, RACUST.CUSTOMER_NAME
, RACUST.CUSTOMER_NUMBER
, TERMS.CUST_SHIPTO_TERMS_ID
, TERMS.ADDRESS_ID
, TERMS.CUSTOMER_ID
, TERMS.SHIP_FROM_ORG_ID
, TERMS.CUM_CONTROL_CODE
, TERMS.SHIP_METHOD
, TERMS.INTRANSIT_TIME
, TERMS.TIME_UOM_CODE
, TERMS.SHIP_DELIVERY_RULE_NAME
, TERMS.CUM_CURRENT_RECORD_YEAR
, TERMS.CUM_PREVIOUS_RECORD_YEAR
, TERMS.CUM_CURRENT_START_DATE
, TERMS.CUM_PREVIOUS_START_DATE
, TERMS.CUM_ORG_LEVEL_CODE
, TERMS.CUM_SHIPMENT_RULE_CODE
, TERMS.CUM_YESTERD_TIME_CUTOFF
, TERMS.CUST_ASSIGN_SUPPLIER_CD
, TERMS.CUSTOMER_RCV_CALENDAR_CD
, TERMS.FREIGHT_CODE
, TERMS.SUPPLIER_SHP_CALENDAR_CD
, TERMS.UNSHIP_FIRM_CUTOFF_DAYS
, TERMS.UNSHIPPED_FIRM_DISP_CD
, TERMS.USE_EDI_SDP_CODE_FLAG
, TERMS.DEMAND_TOLERANCE_ABOVE
, TERMS.DEMAND_TOLERANCE_BELOW
, TERMS.INACTIVE_DATE
, TERMS.MATCH_ACROSS_KEY
, TERMS.MATCH_WITHIN_KEY
, TERMS.HEADER_ID
, TERMS.PRICE_LIST_ID
, TERMS.CRITICAL_ATTRIBUTE_KEY
, TERMS.CUSTOMER_CONTACT_ID
, TERMS.PLN_FIRM_DAY_FROM
, TERMS.PLN_FIRM_DAY_TO
, TERMS.PLN_FORECAST_DAY_FROM
, TERMS.PLN_FORECAST_DAY_TO
, TERMS.PLN_FROZEN_DAY_TO
, TERMS.PLN_FROZEN_DAY_FROM
, TERMS.SEQ_FIRM_DAY_FROM
, TERMS.SEQ_FIRM_DAY_TO
, TERMS.SEQ_FORECAST_DAY_TO
, TERMS.SEQ_FORECAST_DAY_FROM
, TERMS.SEQ_FROZEN_DAY_FROM
, TERMS.SEQ_FROZEN_DAY_TO
, TERMS.SHP_FIRM_DAY_FROM
, TERMS.SHP_FIRM_DAY_TO
, TERMS.SHP_FROZEN_DAY_TO
, TERMS.SHP_FROZEN_DAY_FROM
, TERMS.SHP_FORECAST_DAY_TO
, TERMS.ROUND_TO_STD_PACK_FLAG
, TERMS.SUPPLIER_CONTACT_ID
, TERMS.AGREEMENT_NAME
, TERMS.STD_PACK_QTY
, TERMS.FUTURE_AGREEMENT_NAME
, TERMS.SHP_FORECAST_DAY_FROM
, TERMS.SCHEDULE_HIERARCHY_CODE
, TERMS.COMMENTS
, TERMS.LAST_UPDATED_BY
, TERMS.LAST_UPDATE_DATE
, TERMS.CREATION_DATE
, TERMS.CREATED_BY
, TERMS.ATTRIBUTE_CATEGORY
, TERMS.ATTRIBUTE1
, TERMS.ATTRIBUTE2
, TERMS.ATTRIBUTE3
, TERMS.ATTRIBUTE4
, TERMS.ATTRIBUTE5
, TERMS.ATTRIBUTE6
, TERMS.ATTRIBUTE7
, TERMS.ATTRIBUTE8
, TERMS.ATTRIBUTE9
, TERMS.ATTRIBUTE10
, TERMS.ATTRIBUTE11
, TERMS.ATTRIBUTE12
, TERMS.ATTRIBUTE13
, TERMS.ATTRIBUTE14
, TERMS.ATTRIBUTE15
, TERMS.LAST_UPDATE_LOGIN
, TERMS.REQUEST_ID
, TERMS.PROGRAM_APPLICATION_ID
, TERMS.PROGRAM_ID
, TERMS.PROGRAM_UPDATE_DATE
, TERMS.TP_ATTRIBUTE1
, TERMS.TP_ATTRIBUTE2
, TERMS.TP_ATTRIBUTE3
, TERMS.TP_ATTRIBUTE4
, TERMS.TP_ATTRIBUTE5
, TERMS.TP_ATTRIBUTE6
, TERMS.TP_ATTRIBUTE7
, TERMS.TP_ATTRIBUTE8
, TERMS.TP_ATTRIBUTE9
, TERMS.TP_ATTRIBUTE10
, TERMS.TP_ATTRIBUTE11
, TERMS.TP_ATTRIBUTE12
, TERMS.TP_ATTRIBUTE13
, TERMS.TP_ATTRIBUTE14
, TERMS.TP_ATTRIBUTE15
, TERMS.TP_ATTRIBUTE_CATEGORY
, TERMS.PLN_MRP_FORECAST_DAY_FROM
, TERMS.PLN_MRP_FORECAST_DAY_TO
, TERMS.SHP_MRP_FORECAST_DAY_FROM
, TERMS.SHP_MRP_FORECAST_DAY_TO
, TERMS.SEQ_MRP_FORECAST_DAY_FROM
, TERMS.SEQ_MRP_FORECAST_DAY_TO
, TERMS.INTRANSIT_CALC_BASIS
, TERMS.DEFAULT_SHIP_FROM
, TERMS.PLN_FROZEN_FLAG
, TERMS.SHP_FROZEN_FLAG
, TERMS.SEQ_FROZEN_FLAG
, TERMS.ISSUE_WARNING_DROP_PARTS_FLAG
, TERMS.ORG_ID
, TERMS.BLANKET_NUMBER
, TERMS.RELEASE_RULE
, TERMS.RELEASE_TIME_FRAME
, TERMS.RELEASE_TIME_FRAME_UOM
FROM RA_CUSTOMERS RACUST
, RLM_CUST_SHIPTO_TERMS TERMS
, ORG_ORGANIZATION_DEFINITIONS ORGDEF
WHERE RACUST.CUSTOMER_ID = TERMS.CUSTOMER_ID
AND RACUST.STATUS = 'A'
AND ORGDEF.ORGANIZATION_ID = TERMS.SHIP_FROM_ORG_ID
AND TERMS.ADDRESS_ID IS NULL