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_PARAMETERS

Line 3794: FROM PO_REQ_LINES_GT PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,

3790: 0,
3791: p_sequence + ROWNUM,
3792: substr(g_linemsg||g_delim||PRL.line_num||g_delim||l_textline,1,240),
3793: 'PO_SUB_REQ_RATE_NULL'
3794: FROM PO_REQ_LINES_GT PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,
3795: GL_SETS_OF_BOOKS SOB
3796: WHERE PRL.requisition_header_id = p_document_id AND
3797: nvl(PRL.cancel_flag, 'N') = 'N' AND
3798: nvl(PRL.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND

Line 3882: FROM PO_REQ_LINES_GT PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,

3878: 0,
3879: p_sequence + ROWNUM,
3880: substr(g_linemsg||g_delim||PRL.line_num||g_delim||l_textline,1,240),
3881: 'PO_ATO_ITEM_NA'
3882: FROM PO_REQ_LINES_GT PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,
3883: MTL_SYSTEM_ITEMS MSI
3884: WHERE PRL.requisition_header_id = p_document_id AND
3885: nvl(PRL.cancel_flag, 'N') = 'N' AND
3886: nvl(PRL.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND

Line 4700: FINANCIALS_SYSTEM_PARAMETERS FSP

4696: 'PO_SUB_REL_RATE_NULL'
4697: FROM PO_DISTRIBUTIONS_GT POD, --
4698: PO_LINE_LOCATIONS_GT POLL,PO_LINES POL,
4699: PO_RELEASES_GT POR,PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,
4700: FINANCIALS_SYSTEM_PARAMETERS FSP
4701: WHERE POLL.po_release_id = POR.po_release_id
4702: AND POD.line_location_id = POLL.line_location_id
4703: AND POLL.po_line_id = POL.po_line_id
4704: AND POH.po_header_id = POR.po_header_id

Line 5147: FINANCIALS_SYSTEM_PARAMETERS FSP

5143: --
5144: 'PO_SUB_ITEM_NOT_APPROVED_REL'
5145: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS_GT PLL,
5146: PO_RELEASES_GT POR,PO_LINES POL, PO_HEADERS_GT POH,
5147: FINANCIALS_SYSTEM_PARAMETERS FSP
5148: WHERE POR.po_release_id = p_document_id
5149: AND POR.po_header_id = POH.po_header_id
5150: AND POR.po_header_id = POL.po_header_id
5151: AND POL.po_line_id = PLL.po_line_id

Line 5249: FINANCIALS_SYSTEM_PARAMETERS FSP

5245: --
5246: 'PO_SUB_ITEM_ASL_DEBARRED_REL'
5247: FROM PO_LINE_LOCATIONS_GT PLL,
5248: PO_RELEASES_GT POR,PO_LINES POL, PO_HEADERS_GT POH,
5249: FINANCIALS_SYSTEM_PARAMETERS FSP
5250: WHERE POR.po_release_id = p_document_id
5251: AND POR.po_header_id = POH.po_header_id
5252: AND POR.po_header_id = POL.po_header_id
5253: AND POL.po_line_id = PLL.po_line_id

Line 5332: financials_system_parameters FSP,

5328: ||l_textline,1,240),
5329: 'PO_ATO_ITEM_NA'
5330: FROM po_lines POL,
5331: po_line_locations_gt PLL,
5332: financials_system_parameters FSP,
5333: mtl_system_items MSI
5334: WHERE PLL.po_release_id = p_document_id
5335: AND PLL.po_line_id = POL.po_line_id
5336: AND POL.item_id is not null

Line 6294: FROM fnd_currencies FND, financials_system_parameters FSP,

6290: --used for rounding while checking for tolerance
6291: BEGIN
6292: SELECT FND.currency_code, nvl(FND.extended_precision,5)
6293: INTO l_pou_func_curr, l_pou_func_curr_ext_precn
6294: FROM fnd_currencies FND, financials_system_parameters FSP,
6295: gl_sets_of_books SOB
6296: WHERE FSP.set_of_books_id = SOB.set_of_books_id
6297: AND SOB.currency_code = FND.currency_code;
6298: EXCEPTION

Line 6422: FINANCIALS_SYSTEM_PARAMETERS FSP

6418: NVL(POSP.price_change_allowance/100,-1))
6419: INTO l_price_tolerance_allowed
6420: FROM MTL_SYSTEM_ITEMS MSI,
6421: PO_SYSTEM_PARAMETERS POSP,
6422: FINANCIALS_SYSTEM_PARAMETERS FSP
6423: WHERE msi.inventory_item_id(+) = l_item_id(shipment_line)
6424: AND MSI.organization_id(+) = FSP.inventory_organization_id;
6425:
6426: l_progress := '012';

Line 7246: FINANCIALS_SYSTEM_PARAMETERS FSP

7242: l_rate_date,
7243: l_acceptance_required
7244: FROM PO_HEADERS_GT POH,
7245: GL_SETS_OF_BOOKS SOB,
7246: FINANCIALS_SYSTEM_PARAMETERS FSP
7247: WHERE POH.po_header_id = p_document_id
7248: AND SOB.set_of_books_id = FSP.set_of_books_id;
7249: EXCEPTION
7250: WHEN NO_DATA_FOUND THEN

Line 8523: PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,FINANCIALS_SYSTEM_PARAMETERS FSP

8519: ||g_distmsg||g_delim||POD.distribution_num||g_delim
8520: ||l_textline,1,240),
8521: 'PO_SUB_DIST_RATE_NULL'
8522: FROM PO_DISTRIBUTIONS_GT POD,PO_LINE_LOCATIONS_GT PLL,PO_LINES_GT POL,
8523: PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,FINANCIALS_SYSTEM_PARAMETERS FSP
8524: WHERE POD.po_header_id = POH.po_header_id
8525: AND POD.line_location_id = PLL.line_location_id
8526: AND PLL.po_line_id = POL.po_line_id
8527: AND POH.po_header_id = p_document_id

Line 8582: PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,FINANCIALS_SYSTEM_PARAMETERS FSP

8578: ||g_distmsg||g_delim||POD.distribution_num||g_delim
8579: ||l_textline,1,240),
8580: 'PO_SUB_DIST_RATE_NOT_NULL'
8581: FROM PO_DISTRIBUTIONS_GT POD,PO_LINE_LOCATIONS_GT PLL,PO_LINES_GT POL,
8582: PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,FINANCIALS_SYSTEM_PARAMETERS FSP
8583: WHERE POD.po_header_id = POH.po_header_id
8584: AND POD.line_location_id = PLL.line_location_id
8585: AND PLL.po_line_id = POL.po_line_id
8586: AND POH.po_header_id = p_document_id

Line 8966: FINANCIALS_SYSTEM_PARAMETERS FSP

8962: ||l_textline,1,240),
8963: 'PO_SUB_ITEM_NOT_APPROVED'
8964: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS_GT PLL,
8965: PO_LINES_GT POL, PO_HEADERS_GT POH,
8966: FINANCIALS_SYSTEM_PARAMETERS FSP
8967: WHERE POH.po_header_id = p_document_id
8968: AND POH.po_header_id = POL.po_header_id
8969: AND PLL.po_line_id(+) = POL.po_line_id
8970: AND PLL.po_release_id IS NULL

Line 9070: FINANCIALS_SYSTEM_PARAMETERS FSP

9066: ||l_textline,1,240),
9067: 'PO_SUB_ITEM_ASL_DEBARRED'
9068: FROM PO_LINE_LOCATIONS_GT PLL,
9069: PO_LINES_GT POL, PO_HEADERS_GT POH,
9070: FINANCIALS_SYSTEM_PARAMETERS FSP
9071: WHERE POH.po_header_id = p_document_id
9072: AND POH.po_header_id = POL.po_header_id
9073: AND PLL.po_line_id(+) = POL.po_line_id
9074: AND PLL.po_release_id IS NULL

Line 9439: financials_system_parameters FSP,

9435: 'PO_PO_PLANNED_ITEM_DATE_REQ'
9436: FROM po_lines_gt POL,
9437: po_headers_gt POH,
9438: po_line_locations_gt PLL,
9439: financials_system_parameters FSP,
9440: mtl_system_items MSI
9441: WHERE POH.po_header_id = p_document_id
9442: AND POL.po_header_id = POH.po_header_id
9443: AND POL.po_line_id = PLL.po_line_id

Line 10941: from po_headers_gt ph,po_lines_gt pl,mtl_system_items itm,financials_system_parameters fsp,po_line_types_b plt

10937: 0,
10938: p_sequence + ROWNUM,
10939: substr(g_linemsg||g_delim||pl.line_num||g_delim||l_textline,1,240),
10940: 'PO_ALL_NO_ITEM'
10941: from po_headers_gt ph,po_lines_gt pl,mtl_system_items itm,financials_system_parameters fsp,po_line_types_b plt
10942: where itm.inventory_item_id = pl.item_id
10943: and pl.item_id is not null
10944: and itm.organization_id = fsp.inventory_organization_id
10945: and itm.purchasing_enabled_flag = 'N'

Line 11144: FINANCIALS_SYSTEM_PARAMETERS FSP

11140: ||l_textline,1,240),
11141: 'PO_SUB_ITEM_ASL_DEBARRED'
11142: FROM PO_LINE_LOCATIONS_GT PLL,
11143: PO_LINES_GT POL, PO_HEADERS_GT POH,
11144: FINANCIALS_SYSTEM_PARAMETERS FSP
11145: WHERE POH.po_header_id = p_document_id
11146: AND POH.po_header_id = POL.po_header_id
11147: AND PLL.po_line_id(+) = POL.po_line_id
11148: AND PLL.po_release_id IS NULL