APPS.JAI_PO_HOOK_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 74: FROM po_requisition_lines_all

70: RetCode OUT NOCOPY VARCHAR2
71: ) IS
72: CURSOR reqn_cur IS
73: SELECT *
74: FROM po_requisition_lines_all
75: WHERE requisition_header_id = p_header_id;
76:
77: CURSOR c_uom(pv_unit_of_measure VARCHAR2) IS
78: SELECT uom_code

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

1176: ) RETURN NUMBER IS
1177: /* Get the requisition tax amount for each requisition line currency code wise*/
1178: CURSOR c_reqn_tax_amt IS
1179: SELECT rtl.requisition_line_id, rtl.currency, rtl.tax_amount, nvl(tax.rounding_factor, 0) rnd_factor
1180: FROM JAI_PO_REQ_LINE_TAXES rtl, JAI_CMN_TAXES_ALL tax , po_requisition_lines_all porl
1181: WHERE rtl.requisition_header_id = p_header_id
1182: AND (rtl.requisition_line_id = p_line_id OR p_line_id IS NULL)
1183: AND porl.requisition_line_id = rtl.requisition_line_id
1184: /*Bug 14031501 - Added check on modified_by_agent_flag to exclude tax of the parent line in case Requisition has been split*/

Line 1193: FROM po_requisition_lines_all iprla

1189: (
1190: porl.modified_by_agent_flag IS NOT NULL
1191: AND
1192: NOT EXISTS (SELECT 1
1193: FROM po_requisition_lines_all iprla
1194: WHERE iprla.requisition_header_id = p_header_id
1195: AND iprla.parent_req_line_id = porl.requisition_line_id)
1196: )
1197: )

Line 1210: FROM po_requisition_lines_all

1206: GROUP BY shipment_line_id, currency;
1207: /* Get the conversion rate for the currency code for the requisition line */
1208: CURSOR c_conv_Rate(cp_reqn_line_id NUMBER) IS
1209: SELECT rate, currency_code, cancel_flag, org_id
1210: FROM po_requisition_lines_all
1211: WHERE requisition_line_id = cp_reqn_line_id;
1212: /* Get the conversion rate for the currency code for the receipt shipment line */
1213: CURSOR c_conv_rate_rcpt(cp_shipment_line_id IN NUMBER) IS
1214: SELECT currency_conversion_rate, currency_code

Line 1584: FROM po_requisition_lines_all

1580: GROUP BY requisition_line_id, currency;
1581: /* Get the conversion rate for the currency code for the requisition line */
1582: CURSOR c_conv_Rate(cp_reqn_line_id NUMBER) IS
1583: SELECT rate, currency_code, cancel_flag, org_id
1584: FROM po_requisition_lines_all
1585: WHERE requisition_line_id = cp_reqn_line_id;
1586:
1587: CURSOR c_sob_curr(cp_org_id NUMBER) IS
1588: SELECT currency_code

Line 2310: , po_requisition_lines_all prla

2306: , NVL(tax.rounding_factor, 0) rnd_factor
2307: FROM
2308: jai_po_req_line_taxes rtl
2309: , jai_cmn_taxes_all tax
2310: , po_requisition_lines_all prla
2311: WHERE rtl.requisition_header_id = pn_header_id
2312: AND (rtl.requisition_line_id = pn_line_id OR pn_line_id IS NULL)
2313: AND prla.requisition_line_id = rtl.requisition_line_id
2314: AND tax.tax_id = rtl.tax_id

Line 2324: FROM po_requisition_lines_all iprla

2320: (
2321: prla.modified_by_agent_flag IS NOT NULL
2322: AND
2323: NOT EXISTS (SELECT 1
2324: FROM po_requisition_lines_all iprla
2325: WHERE iprla.requisition_header_id = pn_header_id
2326: AND iprla.parent_req_line_id = prla.requisition_line_id)
2327: )
2328: )

Line 2339: FROM po_requisition_lines_all

2335: rate
2336: , currency_code
2337: , cancel_flag
2338: , org_id
2339: FROM po_requisition_lines_all
2340: WHERE requisition_line_id = cp_reqn_line_id;
2341:
2342: --Get the receipt tax amount for each shipment line currency code
2343: CURSOR rcpt_tax_amt_csr IS