APPS.PO_WF_REQ_NOTIFICATION dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 165: po_req_distributions_all rd

161: AND NVL(modified_by_agent_flag, 'N') = 'N';
162: cursor req_tax_csr(p_doc_id number) is
163: SELECT nvl(sum(nonrecoverable_tax), 0)
164: FROM po_requisition_lines_all rl,
165: po_req_distributions_all rd
166: WHERE rl.requisition_header_id = p_doc_id
167: AND rd.requisition_line_id = rl.requisition_line_id
168: AND NVL(rl.cancel_flag,'N') = 'N'
169: AND NVL(rl.modified_by_agent_flag, 'N') = 'N';

Line 337: po_req_distributions_all rd --

333:
334: SELECT nvl(sum(nonrecoverable_tax), 0)
335: INTO l_tax_amt
336: FROM po_requisition_lines rl,
337: po_req_distributions_all rd --
338: WHERE rl.requisition_header_id = l_document_id
339: AND rd.requisition_line_id = rl.requisition_line_id;
340:
341: if (display_type = 'text/html') then

Line 602: po_req_distributions_all rd --

598:
599: SELECT nvl(sum(nonrecoverable_tax), 0)
600: INTO l_tax_amt
601: FROM po_requisition_lines rl,
602: po_req_distributions_all rd --
603: WHERE rl.requisition_header_id = l_document_id
604: AND rd.requisition_line_id = rl.requisition_line_id;
605:
606: if (display_type = 'text/html') then

Line 844: po_req_distributions_all rd --

840:
841: SELECT nvl(sum(nonrecoverable_tax), 0)
842: INTO l_tax_amt
843: FROM po_requisition_lines rl,
844: po_req_distributions_all rd --
845: WHERE rl.requisition_header_id = l_document_id
846: AND rd.requisition_line_id = rl.requisition_line_id;
847:
848: if (display_type = 'text/html') then

Line 1070: po_req_distributions_all rd --

1066:
1067: SELECT nvl(sum(nonrecoverable_tax), 0)
1068: INTO l_tax_amt
1069: FROM po_requisition_lines rl,
1070: po_req_distributions_all rd --
1071: WHERE rl.requisition_header_id = l_document_id
1072: AND rd.requisition_line_id = rl.requisition_line_id;
1073:
1074: if (display_type = 'text/html') then

Line 1498: FROM PO_REQ_DISTRIBUTIONS_ALL

1494: ORDER BY rql.line_num;
1495:
1496: CURSOR ccId_csr(req_line_id NUMBER) IS
1497: SELECT CODE_COMBINATION_ID
1498: FROM PO_REQ_DISTRIBUTIONS_ALL
1499: WHERE REQUISITION_LINE_ID = req_line_id;
1500:
1501: l_notification_id number;
1502: