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.PO_DOCUMENT_CHECKS_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 6380: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

6376: FROM DUAL
6377: WHERE NOT EXISTS
6378: (SELECT DISTINCT 1
6379: FROM PO_REQUISITION_LINES_ALL PRL,
6380: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
6381: GL_SETS_OF_BOOKS SOB
6382: WHERE PRL.LINE_LOCATION_ID = l_line_location_id(shipment_line)
6383: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
6384: AND FSP.ORG_ID = PRL.ORG_ID

Line 6590: FROM financials_system_params_all FSP, gl_sets_of_books SOB

6586: IF l_req_ou_func_curr IS NULL THEN
6587: BEGIN
6588: SELECT SOB.currency_code
6589: INTO l_req_ou_func_curr
6590: FROM financials_system_params_all FSP, gl_sets_of_books SOB
6591: WHERE FSP.set_of_books_id = SOB.set_of_books_id
6592: AND NVL(FSP.org_id, -99) = NVL(l_requesting_org_id(req_line),-99);
6593: EXCEPTION
6594: WHEN OTHERS THEN

Line 6952: FROM financials_system_params_all FSP, gl_sets_of_books SOB

6948: IF l_req_ou_func_curr IS NULL THEN
6949: BEGIN
6950: SELECT SOB.currency_code
6951: INTO l_req_ou_func_curr
6952: FROM financials_system_params_all FSP, gl_sets_of_books SOB
6953: WHERE FSP.set_of_books_id = SOB.set_of_books_id
6954: AND NVL(FSP.org_id, -99) = NVL(l_requesting_org_id(req_line),-99);
6955: EXCEPTION
6956: WHEN OTHERS THEN

Line 9269: financials_system_params_all FSP,

9265: l_textline,1,240),
9266: 'PO_ATO_ITEM_NA'
9267: FROM po_lines_gt POL,
9268: po_headers_gt POH,
9269: financials_system_params_all FSP,
9270: mtl_system_items MSI
9271: WHERE fsp.org_id = poh.org_id
9272: AND POH.po_header_id = p_document_id
9273: AND POL.po_header_id = POH.po_header_id

Line 9323: from po_headers_gt ph, po_lines_gt pl,mtl_system_items itm,financials_system_params_all fsp,po_line_types_b plt

9319: 0,
9320: p_sequence + ROWNUM,
9321: substr(g_linemsg||g_delim||pl.line_num||g_delim||l_textline,1,240),
9322: 'PO_ALL_NO_ITEM'
9323: from po_headers_gt ph, po_lines_gt pl,mtl_system_items itm,financials_system_params_all fsp,po_line_types_b plt
9324: where fsp.org_id = ph.org_id
9325: and itm.inventory_item_id = pl.item_id
9326: and pl.item_id is not null
9327: and itm.organization_id = fsp.inventory_organization_id