DBA Data[Home] [Help]

APPS.PO_FUNDS_CHECKER dependencies on GL_SETS_OF_BOOKS

Line 334: FROM GL_SETS_OF_BOOKS GLSOB,

330: packet_id. */
331:
332: SELECT FC.MINIMUM_ACCOUNTABLE_UNIT, FC.PRECISION
333: INTO l_min_acct_unit , l_precision
334: FROM GL_SETS_OF_BOOKS GLSOB,
335: FINANCIALS_SYSTEM_PARAMETERS FSP,
336: FND_CURRENCIES FC
337: WHERE GLSOB.set_of_books_id = FSP.set_of_books_id
338: AND FC.currency_code = GLSOB.currency_code;

Line 1115: 'gl_sets_of_books glsob, ' ||

1111: 'prh.segment1, ' ||
1112: 'porl.reference_num, ' ||
1113: 'substr(porl.item_description, 1, 40) ' ||
1114: 'from gl_periods glp, ' ||
1115: 'gl_sets_of_books glsob, ' ||
1116: 'financials_system_parameters fsp, ' ||
1117: 'fnd_currencies base_cur, ' ||
1118: 'po_req_distributions pord, ' ||
1119: 'po_requisition_lines porl, ' ||

Line 1298: 'gl_sets_of_books glsob, ' ||

1294: 'decode(pod.req_distribution_id, null, null, ' ||
1295: 'prh.segment1), ' ||
1296: 'substr(pol.item_description, 1, 40) ' ||
1297: 'from gl_periods glp, ' ||
1298: 'gl_sets_of_books glsob, ' ||
1299: 'financials_system_parameters fsp, ' ||
1300: 'fnd_currencies doc_cur, ' ||
1301: 'po_distributions pod, ' ||
1302: 'po_line_locations poll, ' ||

Line 1391: 'gl_sets_of_books glsob, ' ||

1387: 'prh.segment1, ' ||
1388: 'porl.reference_num, ' ||
1389: 'substr(porl.item_description, 1, 40) ' ||
1390: 'from gl_periods glp, ' ||
1391: 'gl_sets_of_books glsob, ' ||
1392: 'financials_system_parameters fsp, ' ||
1393: 'fnd_currencies base_cur, ' ||
1394: 'po_req_distributions pord, ' ||
1395: 'po_requisition_lines porl, ' ||

Line 1592: 'gl_sets_of_books glsob, ' ||

1588: 'decode(pod.req_distribution_id, null, null, ' ||
1589: 'prh.segment1), ' ||
1590: 'substr(pol.item_description, 1, 40) ' ||
1591: 'from gl_periods glp, ' ||
1592: 'gl_sets_of_books glsob, ' ||
1593: 'financials_system_parameters fsp, ' ||
1594: 'fnd_currencies doc_cur, ' ||
1595: 'po_distributions pod, ' ||
1596: 'po_line_locations poll, ' ||

Line 1687: 'gl_sets_of_books glsob, ' ||

1683: 'prh.segment1, ' ||
1684: 'porl.reference_num, ' ||
1685: 'substr(porl.item_description, 1, 40) ' ||
1686: 'from gl_periods glp, ' ||
1687: 'gl_sets_of_books glsob, ' ||
1688: 'financials_system_parameters fsp, ' ||
1689: 'fnd_currencies base_cur, ' ||
1690: 'po_req_distributions pord, ' ||
1691: 'po_requisition_lines porl, ' ||

Line 1888: 'gl_sets_of_books glsob, ' ||

1884: 'decode(pod.req_distribution_id, null, null, ' ||
1885: 'prh.segment1), ' ||
1886: 'substr(pol.item_description, 1, 40) ' ||
1887: 'from gl_periods glp, ' ||
1888: 'gl_sets_of_books glsob, ' ||
1889: 'financials_system_parameters fsp, ' ||
1890: 'fnd_currencies doc_cur, ' ||
1891: 'po_distributions prd, ' ||
1892: 'po_line_locations prll, ' ||

Line 1990: 'gl_sets_of_books glsob, ' ||

1986: 'decode(pod.req_distribution_id, null, null, ' ||
1987: 'prh.segment1), ' ||
1988: 'substr(porl.item_description, 1, 40) ' ||
1989: 'from gl_periods glp, ' ||
1990: 'gl_sets_of_books glsob, ' ||
1991: 'financials_system_parameters fsp, ' ||
1992: 'fnd_currencies doc_cur, ' ||
1993: 'po_distributions prd, ' ||
1994: 'po_line_locations prll, ' ||