DBA Data[Home] [Help]

APPS.JAI_AR_TRX_LINES_PKG dependencies on JAI_AR_TRX_APPS_RELS_T

Line 543: SELECT organization_id, location_id FROM JAI_AR_TRX_APPS_RELS_T;

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

Line 1139: SELECT organization_id FROM JAI_AR_TRX_APPS_RELS_T;

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

Line 1487: SELECT organization_id, location_id FROM JAI_AR_TRX_APPS_RELS_T;

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