DBA Data[Home] [Help]

APPS.PO_CLM_CLO_UTIL dependencies on STANDARD

Line 812: OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE IN (''PA_BLANKET'',''PA_CONTRACT'',''PO_STANDARD'',

808: END IF;
809:
810: IF ProfileValue <> 'N' THEN
811: return ' OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE_CLASS IN (''SOURCING'',''PO'') AND
812: OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE IN (''PA_BLANKET'',''PA_CONTRACT'',''PO_STANDARD'',
813: ''PA_BLANKET_MOD'',''PA_CONTRACT_MOD'',''PO_STANDARD_MOD'',''SOLICITATION_RESPONSE'')';
814: ELSE
815: return ' OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE_CLASS IN (''SOURCING'',''PO'') AND
816: OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE IN (''PA_BLANKET'',''PA_CONTRACT'',''PO_STANDARD'',

Line 813: ''PA_BLANKET_MOD'',''PA_CONTRACT_MOD'',''PO_STANDARD_MOD'',''SOLICITATION_RESPONSE'')';

809:
810: IF ProfileValue <> 'N' THEN
811: return ' OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE_CLASS IN (''SOURCING'',''PO'') AND
812: OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE IN (''PA_BLANKET'',''PA_CONTRACT'',''PO_STANDARD'',
813: ''PA_BLANKET_MOD'',''PA_CONTRACT_MOD'',''PO_STANDARD_MOD'',''SOLICITATION_RESPONSE'')';
814: ELSE
815: return ' OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE_CLASS IN (''SOURCING'',''PO'') AND
816: OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE IN (''PA_BLANKET'',''PA_CONTRACT'',''PO_STANDARD'',
817: ''AUCTION_RESPONSE'',''RFI_RESPONSE'',''RFQ_RESPONSE'')';

Line 816: OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE IN (''PA_BLANKET'',''PA_CONTRACT'',''PO_STANDARD'',

812: OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE IN (''PA_BLANKET'',''PA_CONTRACT'',''PO_STANDARD'',
813: ''PA_BLANKET_MOD'',''PA_CONTRACT_MOD'',''PO_STANDARD_MOD'',''SOLICITATION_RESPONSE'')';
814: ELSE
815: return ' OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE_CLASS IN (''SOURCING'',''PO'') AND
816: OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE IN (''PA_BLANKET'',''PA_CONTRACT'',''PO_STANDARD'',
817: ''AUCTION_RESPONSE'',''RFI_RESPONSE'',''RFQ_RESPONSE'')';
818: END IF;
819: ELSE
820: return ' 1=1 ';