[Home] [Help]
1281: where prh.requisition_header_id = prl.requisition_header_id),'N'),
1282: 'MIPR_OTHERS', (select 'Y'
1283: from po_requisition_headers_all prh
1284: where prh.requisition_header_id = prl.requisition_header_id
1285: AND ICX_DATATEMPLATE_PKG.GET_MIPR_ACCEPTANCE_STATUS(
1286: prl.requisition_header_id) = 'ACCEPT'), 'Y') <> 'Y'
1287:
1288: THEN
1289: NULL