539: AND A.tax_id = B.tax_id
540: ORDER BY 1;
541:
542: CURSOR ORG_CUR IS
543: SELECT organization_id, location_id FROM JAI_AR_TRX_APPS_RELS_T;
544:
545: CURSOR organization_cur IS
546: SELECT A.organization_id, location_id
547: FROM JAI_AR_TRXS A, RA_CUSTOMER_TRX_ALL B
1135: and A.tax_id = B.tax_id
1136: order by 1;
1137:
1138: CURSOR ORG_CUR IS
1139: SELECT organization_id FROM JAI_AR_TRX_APPS_RELS_T;
1140:
1141: CURSOR organization_cur IS
1142: SELECT organization_id
1143: FROM JAI_AR_TRXS
1483: and A.tax_id = B.tax_id
1484: order by 1;
1485:
1486: CURSOR ORG_CUR IS
1487: SELECT organization_id, location_id FROM JAI_AR_TRX_APPS_RELS_T;
1488:
1489: CURSOR organization_cur IS
1490: SELECT organization_id, location_id
1491: FROM JAI_AR_TRXS