[Home] [Help]
1179: AP_CARDS AC,
1180: AP_CARD_PROGRAMS ACP,
1181: MTL_SYSTEM_ITEMS_KFV MSI,
1182: GL_SETS_OF_BOOKS GSB,
1183: FINANCIALS_SYSTEM_PARAMETERS FSP,
1184: iby_creditcard ibycc
1185:
1186: WHERE
1187:
1254: PO_VENDOR_SITES PVS,
1255: AP_CARDS AC,
1256: AP_CARD_PROGRAMS ACP,
1257: GL_SETS_OF_BOOKS GSB,
1258: FINANCIALS_SYSTEM_PARAMETERS FSP,
1259: iby_creditcard ibycc
1260:
1261: WHERE
1262: PH.PO_HEADER_ID = PL.PO_HEADER_ID
1328: PO_VENDOR_SITES PVS,
1329: AP_CARDS AC,
1330: AP_CARD_PROGRAMS ACP,
1331: GL_SETS_OF_BOOKS GSB,
1332: FINANCIALS_SYSTEM_PARAMETERS FSP,
1333: iby_creditcard ibycc
1334:
1335: WHERE
1336: PH.PO_HEADER_ID = PR.PO_HEADER_ID
1405: AP_CARDS AC,
1406: AP_CARD_PROGRAMS ACP,
1407: MTL_SYSTEM_ITEMS_KFV MSI,
1408: GL_SETS_OF_BOOKS GSB,
1409: FINANCIALS_SYSTEM_PARAMETERS FSP,
1410: iby_creditcard ibycc
1411:
1412: WHERE
1413: PH.PO_HEADER_ID = PR.PO_HEADER_ID
1475: PO_VENDOR_SITES PVS,
1476: AP_CARDS AC,
1477: AP_CARD_PROGRAMS ACP,
1478: GL_SETS_OF_BOOKS GSB,
1479: FINANCIALS_SYSTEM_PARAMETERS FSP,
1480: iby_creditcard ibycc
1481:
1482: WHERE
1483: PH.TYPE_LOOKUP_CODE = 'STANDARD'
1533: PO_VENDOR_SITES PVS,
1534: AP_CARDS AC,
1535: AP_CARD_PROGRAMS ACP,
1536: GL_SETS_OF_BOOKS GSB,
1537: FINANCIALS_SYSTEM_PARAMETERS FSP,
1538: iby_creditcard ibycc
1539:
1540: WHERE
1541: PH.PO_HEADER_ID = PR.PO_HEADER_ID
1876: l_progress := '200';
1877:
1878: SELECT fsp.inventory_organization_id, gsb.chart_of_accounts_id, gsb.currency_code
1879: INTO g_inv_org_id, l_org_chart_of_accounts_id, l_func_curr_code
1880: FROM financials_system_parameters fsp,
1881: gl_sets_of_books gsb
1882: WHERE fsp.set_of_books_id = gsb.set_of_books_id
1883: AND fsp.org_id = g_org_id;
1884: