APPS.PO_DOCUMENT_CHECKS_PVT dependencies on GL_SETS_OF_BOOKS

Line 1996: GL_SETS_OF_BOOKS SOB

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
2000: SOB.set_of_books_id = FSP.set_of_books_id AND

Line 2891: PO_RELEASES_GT POR,PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,

2887: ||l_textline,1,240),
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

Line 4315: gl_sets_of_books SOB

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
4319: WHEN OTHERS THEN

Line 4393: FROM financials_system_params_all FSP, gl_sets_of_books SOB

4389: IF l_req_ou_func_curr IS NULL THEN
4390: BEGIN
4391: SELECT SOB.currency_code
4392: INTO l_req_ou_func_curr
4393: FROM financials_system_params_all FSP, gl_sets_of_books SOB
4394: WHERE FSP.set_of_books_id = SOB.set_of_books_id
4395: AND NVL(FSP.org_id, -99) = NVL(l_requesting_org_id(req_line),-99);
4396: EXCEPTION
4397: WHEN OTHERS THEN

Line 4627: FROM financials_system_params_all FSP, gl_sets_of_books SOB

4623: IF l_req_ou_func_curr IS NULL THEN
4624: BEGIN
4625: SELECT SOB.currency_code
4626: INTO l_req_ou_func_curr
4627: FROM financials_system_params_all FSP, gl_sets_of_books SOB
4628: WHERE FSP.set_of_books_id = SOB.set_of_books_id
4629: AND NVL(FSP.org_id, -99) = NVL(l_requesting_org_id(req_line),-99);
4630: EXCEPTION
4631: WHEN OTHERS THEN

Line 4909: GL_SETS_OF_BOOKS SOB,

4905: l_rate_type,
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

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