APPS.JAI_PO_HOOK_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 34: FROM po_requisition_lines_all

30: RetCode OUT NOCOPY VARCHAR2
31: ) IS
32: CURSOR reqn_cur IS
33: SELECT *
34: FROM po_requisition_lines_all
35: WHERE requisition_header_id = p_header_id;
36:
37: CURSOR c_uom(pv_unit_of_measure VARCHAR2) IS
38: SELECT uom_code

Line 1065: FROM JAI_PO_REQ_LINE_TAXES rtl, JAI_CMN_TAXES_ALL tax , po_requisition_lines_all porl

1061: ) RETURN NUMBER IS
1062: /* Get the requisition tax amount for each requisition line currency code wise*/
1063: CURSOR c_reqn_tax_amt IS
1064: SELECT rtl.requisition_line_id, rtl.currency, rtl.tax_amount, nvl(tax.rounding_factor, 0) rnd_factor
1065: FROM JAI_PO_REQ_LINE_TAXES rtl, JAI_CMN_TAXES_ALL tax , po_requisition_lines_all porl
1066: WHERE rtl.requisition_header_id = p_header_id
1067: AND (rtl.requisition_line_id = p_line_id OR p_line_id IS NULL)
1068: AND porl.requisition_line_id = rtl.requisition_line_id
1069: AND tax.tax_id = rtl.tax_id

Line 1081: FROM po_requisition_lines_all

1077: GROUP BY shipment_line_id, currency;
1078: /* Get the conversion rate for the currency code for the requisition line */
1079: CURSOR c_conv_Rate(cp_reqn_line_id NUMBER) IS
1080: SELECT rate, currency_code, cancel_flag, org_id
1081: FROM po_requisition_lines_all
1082: WHERE requisition_line_id = cp_reqn_line_id;
1083: /* Get the conversion rate for the currency code for the receipt shipment line */
1084: CURSOR c_conv_rate_rcpt(cp_shipment_line_id IN NUMBER) IS
1085: SELECT currency_conversion_rate, currency_code

Line 1455: FROM po_requisition_lines_all

1451: GROUP BY requisition_line_id, currency;
1452: /* Get the conversion rate for the currency code for the requisition line */
1453: CURSOR c_conv_Rate(cp_reqn_line_id NUMBER) IS
1454: SELECT rate, currency_code, cancel_flag, org_id
1455: FROM po_requisition_lines_all
1456: WHERE requisition_line_id = cp_reqn_line_id;
1457:
1458: CURSOR c_sob_curr(cp_org_id NUMBER) IS
1459: SELECT currency_code

Line 2122: , po_requisition_lines_all prla

2118: , NVL(tax.rounding_factor, 0) rnd_factor
2119: FROM
2120: jai_po_req_line_taxes rtl
2121: , jai_cmn_taxes_all tax
2122: , po_requisition_lines_all prla
2123: WHERE rtl.requisition_header_id = pn_header_id
2124: AND (rtl.requisition_line_id = pn_line_id OR pn_line_id IS NULL)
2125: AND prla.requisition_line_id = rtl.requisition_line_id
2126: AND tax.tax_id = rtl.tax_id

Line 2137: FROM po_requisition_lines_all

2133: rate
2134: , currency_code
2135: , cancel_flag
2136: , org_id
2137: FROM po_requisition_lines_all
2138: WHERE requisition_line_id = cp_reqn_line_id;
2139:
2140: --Get the receipt tax amount for each shipment line currency code
2141: CURSOR rcpt_tax_amt_csr IS