eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_PO_LINE_LOCATIONS

Line 1614: from JAI_PO_LINE_LOCATIONS jpoll

1610:
1611: cursor c_get_po_line_loc_srvtyp (cp_po_line_id po_lines_all.po_line_id%type )
1612: is
1613: select service_type_code, sum(jpollt.tax_amount) service_tax_amount
1614: from JAI_PO_LINE_LOCATIONS jpoll
1615: ,jai_po_taxes jpollt
1616: where jpoll.po_line_id = cp_po_line_id
1617: and jpollt.line_location_id = jpoll.line_location_id
1618: /*added the cess and sh cess tax types for bug#6457710*/

Line 1627: from JAI_PO_LINE_LOCATIONS jpoll

1623: /*Bug 12902363 - Start*/
1624: cursor c_get_rcv_line_loc_srvtyp (cp_po_line_id po_lines_all.po_line_id%type )
1625: is
1626: select service_type_code, sum(jrlt.tax_amount) service_tax_amount
1627: from JAI_PO_LINE_LOCATIONS jpoll
1628: ,jai_rcv_line_taxes jrlt
1629: ,rcv_transactions rt
1630: where jpoll.po_line_id = cp_po_line_id
1631: and rt.po_line_id = cp_po_line_id

Line 3181: update JAI_PO_LINE_LOCATIONS set service_type_code = rec.service_type_code

3177: -- Update the transaction tables with the service type code based on source value
3178: --
3179: if rec.transaction_source in ('PURCHASING', 'RECEIVING') /*Updated by nprashar for bug # 6841116*/ then
3180:
3181: update JAI_PO_LINE_LOCATIONS set service_type_code = rec.service_type_code
3182: , last_update_date = sysdate
3183: , last_updated_by = lv_user_id
3184: , last_update_login = lv_login_id
3185: where po_header_id = rec.document_id