DBA Data[Home] [Help]

APPS.POA_DBI_NEG_PKG dependencies on STANDARD

Line 1656: decode(i.contract_type, ''BLANKET'', ''Blanket Agreement'',''STANDARD'', ''Standard PO'',''CONTRACT'',''Contract Agreement'' ) POA_ATTRIBUTE9,

1652: negorg.name POA_ATTRIBUTE5,
1653: doctl.name POA_ATTRIBUTE6,
1654: hrv.value POA_ATTRIBUTE7,
1655: supv.value POA_ATTRIBUTE8,
1656: decode(i.contract_type, ''BLANKET'', ''Blanket Agreement'',''STANDARD'', ''Standard PO'',''CONTRACT'',''Contract Agreement'' ) POA_ATTRIBUTE9,
1657: poh.segment1 POA_ATTRIBUTE10,
1658: uom.description POA_ATTRIBUTE11,
1659: i.POA_MEASURE1 POA_MEASURE1,
1660: i.POA_MEASURE2 POA_MEASURE2,

Line 1667: || poh.revision_num || ''&LanguageCode='' || userenv(''LANG'') || ''&DocumentType=PO&DocumentSubtype=STANDARD&OrgId='' || poh.org_id

1663: decode(i.po_header_id, null, null,
1664: decode(poh.authorization_status,''APPROVED'',
1665: ''pFunctionName=POA_DBI_ISP_DRILL&PoHeaderId=''||i.po_header_id||''&addBreadCrumb=Y&retainAM=Y'',
1666: ''pFunctionName=POA_DBI_PDF_DRILL&DocumentId='' || i.po_header_id || ''&RevisionNum=''
1667: || poh.revision_num || ''&LanguageCode='' || userenv(''LANG'') || ''&DocumentType=PO&DocumentSubtype=STANDARD&OrgId='' || poh.org_id
1668: || ''&UserSecurity=Y&StoreFlag=N&ViewOrCommunicate=View&CallFromForm=N''
1669: )) POA_ATTRIBUTE15,
1670: i.POA_ATTRIBUTE16 POA_ATTRIBUTE16,
1671: i.POA_ATTRIBUTE17 POA_ATTRIBUTE17