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 1995: FROM PO_REQ_LINES_GT PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,

1991: 0,
1992: p_sequence + ROWNUM,
1993: substr(g_linemsg||g_delim||PRL.line_num||g_delim||l_textline,1,240),
1994: 'PO_SUB_REQ_RATE_NULL'
1995: FROM PO_REQ_LINES_GT PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,
1996: GL_SETS_OF_BOOKS SOB
1997: WHERE PRL.requisition_header_id = p_document_id AND
1998: nvl(PRL.cancel_flag, 'N') = 'N' AND
1999: nvl(PRL.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND

Line 2083: FROM PO_REQ_LINES_GT PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,

2079: 0,
2080: p_sequence + ROWNUM,
2081: substr(g_linemsg||g_delim||PRL.line_num||g_delim||l_textline,1,240),
2082: 'PO_ATO_ITEM_NA'
2083: FROM PO_REQ_LINES_GT PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,
2084: MTL_SYSTEM_ITEMS MSI
2085: WHERE PRL.requisition_header_id = p_document_id AND
2086: nvl(PRL.cancel_flag, 'N') = 'N' AND
2087: nvl(PRL.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND

Line 2892: FINANCIALS_SYSTEM_PARAMETERS FSP

2888: 'PO_SUB_REL_RATE_NULL'
2889: FROM PO_DISTRIBUTIONS_GT POD, --
2890: PO_LINE_LOCATIONS_GT POLL,PO_LINES POL,
2891: PO_RELEASES_GT POR,PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,
2892: FINANCIALS_SYSTEM_PARAMETERS FSP
2893: WHERE POLL.po_release_id = POR.po_release_id
2894: AND POD.line_location_id = POLL.line_location_id
2895: AND POLL.po_line_id = POL.po_line_id
2896: AND POH.po_header_id = POR.po_header_id

Line 3310: FINANCIALS_SYSTEM_PARAMETERS FSP

3306: --
3307: 'PO_SUB_ITEM_NOT_APPROVED_REL'
3308: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS_GT PLL,
3309: PO_RELEASES_GT POR,PO_LINES POL, PO_HEADERS_GT POH,
3310: FINANCIALS_SYSTEM_PARAMETERS FSP
3311: WHERE POR.po_release_id = p_document_id
3312: AND POR.po_header_id = POH.po_header_id
3313: AND POR.po_header_id = POL.po_header_id
3314: AND POL.po_line_id = PLL.po_line_id

Line 3412: FINANCIALS_SYSTEM_PARAMETERS FSP

3408: --
3409: 'PO_SUB_ITEM_ASL_DEBARRED_REL'
3410: FROM PO_LINE_LOCATIONS_GT PLL,
3411: PO_RELEASES_GT POR,PO_LINES POL, PO_HEADERS_GT POH,
3412: FINANCIALS_SYSTEM_PARAMETERS FSP
3413: WHERE POR.po_release_id = p_document_id
3414: AND POR.po_header_id = POH.po_header_id
3415: AND POR.po_header_id = POL.po_header_id
3416: AND POL.po_line_id = PLL.po_line_id

Line 3495: financials_system_parameters FSP,

3491: ||l_textline,1,240),
3492: 'PO_ATO_ITEM_NA'
3493: FROM po_lines POL,
3494: po_line_locations_gt PLL,
3495: financials_system_parameters FSP,
3496: mtl_system_items MSI
3497: WHERE PLL.po_release_id = p_document_id
3498: AND PLL.po_line_id = POL.po_line_id
3499: AND POL.item_id is not null

Line 4314: FROM fnd_currencies FND, financials_system_parameters FSP,

4310: --used for rounding while checking for tolerance
4311: BEGIN
4312: SELECT FND.currency_code, nvl(FND.extended_precision,5)
4313: INTO l_pou_func_curr, l_pou_func_curr_ext_precn
4314: FROM fnd_currencies FND, financials_system_parameters FSP,
4315: gl_sets_of_books SOB
4316: WHERE FSP.set_of_books_id = SOB.set_of_books_id
4317: AND SOB.currency_code = FND.currency_code;
4318: EXCEPTION

Line 4480: FINANCIALS_SYSTEM_PARAMETERS FSP

4476: NVL(POSP.price_change_allowance/100,-1))
4477: INTO l_price_tolerance_allowed
4478: FROM MTL_SYSTEM_ITEMS MSI,
4479: PO_SYSTEM_PARAMETERS POSP,
4480: FINANCIALS_SYSTEM_PARAMETERS FSP
4481: WHERE msi.inventory_item_id(+) = l_item_id(shipment_line)
4482: AND MSI.organization_id(+) = FSP.inventory_organization_id;
4483:
4484: l_progress := '008';

Line 4910: FINANCIALS_SYSTEM_PARAMETERS FSP

4906: l_rate,
4907: l_rate_date
4908: FROM PO_HEADERS_GT POH,
4909: GL_SETS_OF_BOOKS SOB,
4910: FINANCIALS_SYSTEM_PARAMETERS FSP
4911: WHERE POH.po_header_id = p_document_id
4912: AND SOB.set_of_books_id = FSP.set_of_books_id;
4913: EXCEPTION
4914: WHEN NO_DATA_FOUND THEN

Line 5879: PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,FINANCIALS_SYSTEM_PARAMETERS FSP

5875: ||g_distmsg||g_delim||POD.distribution_num||g_delim
5876: ||l_textline,1,240),
5877: 'PO_SUB_DIST_RATE_NULL'
5878: FROM PO_DISTRIBUTIONS_GT POD,PO_LINE_LOCATIONS_GT PLL,PO_LINES_GT POL,
5879: PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,FINANCIALS_SYSTEM_PARAMETERS FSP
5880: WHERE POD.po_header_id = POH.po_header_id
5881: AND POD.line_location_id = PLL.line_location_id
5882: AND PLL.po_line_id = POL.po_line_id
5883: AND POH.po_header_id = p_document_id

Line 5938: PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,FINANCIALS_SYSTEM_PARAMETERS FSP

5934: ||g_distmsg||g_delim||POD.distribution_num||g_delim
5935: ||l_textline,1,240),
5936: 'PO_SUB_DIST_RATE_NOT_NULL'
5937: FROM PO_DISTRIBUTIONS_GT POD,PO_LINE_LOCATIONS_GT PLL,PO_LINES_GT POL,
5938: PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,FINANCIALS_SYSTEM_PARAMETERS FSP
5939: WHERE POD.po_header_id = POH.po_header_id
5940: AND POD.line_location_id = PLL.line_location_id
5941: AND PLL.po_line_id = POL.po_line_id
5942: AND POH.po_header_id = p_document_id

Line 6319: FINANCIALS_SYSTEM_PARAMETERS FSP

6315: ||l_textline,1,240),
6316: 'PO_SUB_ITEM_NOT_APPROVED'
6317: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS_GT PLL,
6318: PO_LINES_GT POL, PO_HEADERS_GT POH,
6319: FINANCIALS_SYSTEM_PARAMETERS FSP
6320: WHERE POH.po_header_id = p_document_id
6321: AND POH.po_header_id = POL.po_header_id
6322: AND PLL.po_line_id(+) = POL.po_line_id
6323: AND PLL.po_release_id IS NULL

Line 6416: FINANCIALS_SYSTEM_PARAMETERS FSP

6412: ||l_textline,1,240),
6413: 'PO_SUB_ITEM_ASL_DEBARRED'
6414: FROM PO_LINE_LOCATIONS_GT PLL,
6415: PO_LINES_GT POL, PO_HEADERS_GT POH,
6416: FINANCIALS_SYSTEM_PARAMETERS FSP
6417: WHERE POH.po_header_id = p_document_id
6418: AND POH.po_header_id = POL.po_header_id
6419: AND PLL.po_line_id(+) = POL.po_line_id
6420: AND PLL.po_release_id IS NULL

Line 6615: financials_system_parameters FSP,

6611: l_textline,1,240),
6612: 'PO_ATO_ITEM_NA'
6613: FROM po_lines_gt POL,
6614: po_headers_gt POH,
6615: financials_system_parameters FSP,
6616: mtl_system_items MSI
6617: WHERE POH.po_header_id = p_document_id
6618: AND POL.po_header_id = POH.po_header_id
6619: AND POL.item_id is not null

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

6663: 0,
6664: p_sequence + ROWNUM,
6665: substr(g_linemsg||g_delim||pl.line_num||g_delim||l_textline,1,240),
6666: 'PO_ALL_NO_ITEM'
6667: from po_headers_gt ph, po_lines_gt pl,mtl_system_items itm,financials_system_parameters fsp,po_line_types_b plt
6668: where itm.inventory_item_id = pl.item_id
6669: and pl.item_id is not null
6670: and itm.organization_id = fsp.inventory_organization_id
6671: and itm.purchasing_enabled_flag = 'N'

Line 6781: financials_system_parameters FSP,

6777: 'PO_PO_PLANNED_ITEM_DATE_REQ'
6778: FROM po_lines_gt POL,
6779: po_headers_gt POH,
6780: po_line_locations_gt PLL,
6781: financials_system_parameters FSP,
6782: mtl_system_items MSI
6783: WHERE POH.po_header_id = p_document_id
6784: AND POL.po_header_id = POH.po_header_id
6785: AND POL.po_line_id = PLL.po_line_id

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

7807: 0,
7808: p_sequence + ROWNUM,
7809: substr(g_linemsg||g_delim||pl.line_num||g_delim||l_textline,1,240),
7810: 'PO_ALL_NO_ITEM'
7811: from po_headers_gt ph,po_lines_gt pl,mtl_system_items itm,financials_system_parameters fsp,po_line_types_b plt
7812: where itm.inventory_item_id = pl.item_id
7813: and pl.item_id is not null
7814: and itm.organization_id = fsp.inventory_organization_id
7815: and itm.purchasing_enabled_flag = 'N'