VIEW: APPS.OKI_HPRICE_DTL_V

Source

View Text - Preformatted

SELECT H.ID CHR_ID , AGTL.NAME AGREEMENT_NAME , PLTL.NAME PRICE_LIST , RTTL.NAME PAYMENT_TERM , INV_RULE.NAME INVOICING_RULE , OAB.AGREEMENT_TYPE_CODE AGREEMENT_TYPE FROM OKC_K_HEADERS_ALL_B H , OE_AGREEMENTS_TL AGTL , QP_LIST_HEADERS_TL PLTL , RA_TERMS_TL RTTL , RA_RULES INV_RULE , OKC_GOVERNANCES OG , OE_AGREEMENTS_B OAB WHERE OG.CHR_ID(+) = H.ID AND AGTL.AGREEMENT_ID(+) = OG.ISA_AGREEMENT_ID AND AGTL.LANGUAGE(+) = USERENV( 'LANG' ) AND PLTL.LIST_HEADER_ID(+) = H.PRICE_LIST_ID AND PLTL.LANGUAGE(+) = USERENV( 'LANG' ) AND RTTL.TERM_ID(+) = H.PAYMENT_TERM_ID AND RTTL.LANGUAGE(+) = USERENV( 'LANG' ) AND INV_RULE.RULE_ID(+) = H.INV_RULE_ID AND OAB.AGREEMENT_ID(+) = AGTL.AGREEMENT_ID

View Text - HTML Formatted

SELECT H.ID CHR_ID
, AGTL.NAME AGREEMENT_NAME
, PLTL.NAME PRICE_LIST
, RTTL.NAME PAYMENT_TERM
, INV_RULE.NAME INVOICING_RULE
, OAB.AGREEMENT_TYPE_CODE AGREEMENT_TYPE
FROM OKC_K_HEADERS_ALL_B H
, OE_AGREEMENTS_TL AGTL
, QP_LIST_HEADERS_TL PLTL
, RA_TERMS_TL RTTL
, RA_RULES INV_RULE
, OKC_GOVERNANCES OG
, OE_AGREEMENTS_B OAB
WHERE OG.CHR_ID(+) = H.ID
AND AGTL.AGREEMENT_ID(+) = OG.ISA_AGREEMENT_ID
AND AGTL.LANGUAGE(+) = USERENV( 'LANG' )
AND PLTL.LIST_HEADER_ID(+) = H.PRICE_LIST_ID
AND PLTL.LANGUAGE(+) = USERENV( 'LANG' )
AND RTTL.TERM_ID(+) = H.PAYMENT_TERM_ID
AND RTTL.LANGUAGE(+) = USERENV( 'LANG' )
AND INV_RULE.RULE_ID(+) = H.INV_RULE_ID
AND OAB.AGREEMENT_ID(+) = AGTL.AGREEMENT_ID