eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARRX_TX dependencies on FA_RX_FLEX_PKG

Line 393: FA_RX_FLEX_PKG.FLEX_SQL(

389: IF OPER IS NULL THEN
390: REC_BALANCING_WHERE := NULL;
391: ELSE
392: REC_BALANCING_WHERE := ' AND '||
393: FA_RX_FLEX_PKG.FLEX_SQL(
394: p_application_id => 101,
395: p_id_flex_code => 'GL#',
396: p_id_flex_num => var.chart_of_accounts_id,
397: p_table_alias => 'CCRECDIST',

Line 425: FA_RX_FLEX_PKG.FLEX_SQL(

421: IF OPER IS NULL THEN
422: REC_ACCOUNT_WHERE := NULL;
423: ELSE
424: REC_ACCOUNT_WHERE := ' AND '||
425: FA_RX_FLEX_PKG.FLEX_SQL(
426: p_application_id => 101,
427: p_id_flex_code => 'GL#',
428: p_id_flex_num => var.chart_of_accounts_id,
429: p_table_alias => 'CCRECDIST',

Line 551: FA_RX_FLEX_PKG.FLEX_SQL(

547: --
548: -- Flex SQL
549: --
550: REC_ACCOUNT_SEL :=
551: FA_RX_FLEX_PKG.FLEX_SQL(
552: p_application_id => 101,
553: p_id_flex_code => 'GL#',
554: p_id_flex_num => var.chart_of_accounts_id,
555: p_table_alias => 'CCRECDIST',

Line 559: FA_RX_FLEX_PKG.FLEX_SQL(

555: p_table_alias => 'CCRECDIST',
556: p_mode => 'SELECT',
557: p_qualifier => 'ALL');
558: REC_BALANCE_SEL :=
559: FA_RX_FLEX_PKG.FLEX_SQL(
560: p_application_id => 101,
561: p_id_flex_code => 'GL#',
562: p_id_flex_num => var.chart_of_accounts_id,
563: p_table_alias => 'CCRECDIST',

Line 567: FA_RX_FLEX_PKG.FLEX_SQL(

563: p_table_alias => 'CCRECDIST',
564: p_mode => 'SELECT',
565: p_qualifier => 'GL_BALANCING');
566: REC_NATURAL_SEL :=
567: FA_RX_FLEX_PKG.FLEX_SQL(
568: p_application_id => 101,
569: p_id_flex_code => 'GL#',
570: p_id_flex_num => var.chart_of_accounts_id,
571: p_table_alias => 'CCRECDIST',

Line 814: /* var.rec_account := fa_rx_flex_pkg.get_value(

810: -- Get FLEX FIELD VALUE and DESCRIPTION
811: --
812: fa_rx_util_pkg.debug('GL_GET_FLEX_KEYWORD');
813:
814: /* var.rec_account := fa_rx_flex_pkg.get_value(
815: p_application_id => 101,
816: p_id_flex_code => 'GL#',
817: p_id_flex_num => var.chart_of_accounts_id,
818: p_qualifier => 'ALL',

Line 821: var.rec_account_desc := substrb(fa_rx_flex_pkg.get_description(

817: p_id_flex_num => var.chart_of_accounts_id,
818: p_qualifier => 'ALL',
819: p_ccid => var.ccid);*/
820:
821: var.rec_account_desc := substrb(fa_rx_flex_pkg.get_description(
822: p_application_id => 101,
823: p_id_flex_code => 'GL#',
824: p_id_flex_num => var.chart_of_accounts_id,
825: p_qualifier => 'ALL',

Line 828: /* var.rec_balance := fa_rx_flex_pkg.get_value(

824: p_id_flex_num => var.chart_of_accounts_id,
825: p_qualifier => 'ALL',
826: p_data => var.rec_account),1,240);
827:
828: /* var.rec_balance := fa_rx_flex_pkg.get_value(
829: p_application_id => 101,
830: p_id_flex_code => 'GL#',
831: p_id_flex_num => var.chart_of_accounts_id,
832: p_qualifier => 'GL_BALANCING',

Line 835: var.rec_balance_desc := substrb(fa_rx_flex_pkg.get_description(

831: p_id_flex_num => var.chart_of_accounts_id,
832: p_qualifier => 'GL_BALANCING',
833: p_ccid => var.ccid);*/
834:
835: var.rec_balance_desc := substrb(fa_rx_flex_pkg.get_description(
836: p_application_id => 101,
837: p_id_flex_code => 'GL#',
838: p_id_flex_num => var.chart_of_accounts_id,
839: p_qualifier => 'GL_BALANCING',

Line 842: /* var.rec_natacct := fa_rx_flex_pkg.get_value(

838: p_id_flex_num => var.chart_of_accounts_id,
839: p_qualifier => 'GL_BALANCING',
840: p_data => var.rec_balance),1,240);
841:
842: /* var.rec_natacct := fa_rx_flex_pkg.get_value(
843: p_application_id => 101,
844: p_id_flex_code => 'GL#',
845: p_id_flex_num => var.chart_of_accounts_id,
846: p_qualifier => 'GL_ACCOUNT',

Line 849: var.rec_natacct_desc := substrb(fa_rx_flex_pkg.get_description(

845: p_id_flex_num => var.chart_of_accounts_id,
846: p_qualifier => 'GL_ACCOUNT',
847: p_ccid => var.ccid);*/
848:
849: var.rec_natacct_desc := substrb(fa_rx_flex_pkg.get_description(
850: p_application_id => 101,
851: p_id_flex_code => 'GL#',
852: p_id_flex_num => var.chart_of_accounts_id,
853: p_qualifier => 'GL_ACCOUNT',

Line 1006: get_item := fa_rx_flex_pkg.flex_sql(

1002: oe_profile.get(
1003: name => 'SO_ORGANIZATION_ID',
1004: val => var.so_organization_id);
1005:
1006: get_item := fa_rx_flex_pkg.flex_sql(
1007: p_application_id => 401,
1008: p_id_flex_code => var.so_id_flex_code,
1009: p_id_flex_num => null,
1010: p_table_alias => 'ITEM',

Line 1021: FA_RX_FLEX_PKG.FLEX_SQL(

1017: --
1018: -- Flex SQL
1019: --
1020: CC_ACCOUNT_SEL :=
1021: FA_RX_FLEX_PKG.FLEX_SQL(
1022: p_application_id => 101,
1023: p_id_flex_code => 'GL#',
1024: p_id_flex_num => var.chart_of_accounts_id,
1025: p_table_alias => 'CCDIST',

Line 1029: FA_RX_FLEX_PKG.FLEX_SQL(

1025: p_table_alias => 'CCDIST',
1026: p_mode => 'SELECT',
1027: p_qualifier => 'ALL');
1028: CC_BALANCE_SEL :=
1029: FA_RX_FLEX_PKG.FLEX_SQL(
1030: p_application_id => 101,
1031: p_id_flex_code => 'GL#',
1032: p_id_flex_num => var.chart_of_accounts_id,
1033: p_table_alias => 'CCDIST',

Line 1037: FA_RX_FLEX_PKG.FLEX_SQL(

1033: p_table_alias => 'CCDIST',
1034: p_mode => 'SELECT',
1035: p_qualifier => 'GL_BALANCING');
1036: CC_NATURAL_SEL :=
1037: FA_RX_FLEX_PKG.FLEX_SQL(
1038: p_application_id => 101,
1039: p_id_flex_code => 'GL#',
1040: p_id_flex_num => var.chart_of_accounts_id,
1041: p_table_alias => 'CCDIST',

Line 1127: /* var.account := fa_rx_flex_pkg.get_value(

1123: -- Get FLEX FIELD VALUE and DESCRIPTION
1124: --
1125: fa_rx_util_pkg.debug('AR_GET_FLEX_KEYWORD');
1126:
1127: /* var.account := fa_rx_flex_pkg.get_value(
1128: p_application_id => 101,
1129: p_id_flex_code => 'GL#',
1130: p_id_flex_num => var.chart_of_accounts_id,
1131: p_qualifier => 'ALL',

Line 1134: var.account_desc := substrb(fa_rx_flex_pkg.get_description(

1130: p_id_flex_num => var.chart_of_accounts_id,
1131: p_qualifier => 'ALL',
1132: p_ccid => var.ccid2);*/
1133:
1134: var.account_desc := substrb(fa_rx_flex_pkg.get_description(
1135: p_application_id => 101,
1136: p_id_flex_code => 'GL#',
1137: p_id_flex_num => var.chart_of_accounts_id,
1138: p_qualifier => 'ALL',

Line 1141: /* var.balance := fa_rx_flex_pkg.get_value(

1137: p_id_flex_num => var.chart_of_accounts_id,
1138: p_qualifier => 'ALL',
1139: p_data => var.account), 1, 240);
1140:
1141: /* var.balance := fa_rx_flex_pkg.get_value(
1142: p_application_id => 101,
1143: p_id_flex_code => 'GL#',
1144: p_id_flex_num => var.chart_of_accounts_id,
1145: p_qualifier => 'GL_BALANCING',

Line 1148: var.balance_desc := substrb(fa_rx_flex_pkg.get_description(

1144: p_id_flex_num => var.chart_of_accounts_id,
1145: p_qualifier => 'GL_BALANCING',
1146: p_ccid => var.ccid2);*/
1147:
1148: var.balance_desc := substrb(fa_rx_flex_pkg.get_description(
1149: p_application_id => 101,
1150: p_id_flex_code => 'GL#',
1151: p_id_flex_num => var.chart_of_accounts_id,
1152: p_qualifier => 'GL_BALANCING',

Line 1155: /* var.natacct := fa_rx_flex_pkg.get_value(

1151: p_id_flex_num => var.chart_of_accounts_id,
1152: p_qualifier => 'GL_BALANCING',
1153: p_data => var.balance), 1, 240);
1154:
1155: /* var.natacct := fa_rx_flex_pkg.get_value(
1156: p_application_id => 101,
1157: p_id_flex_code => 'GL#',
1158: p_id_flex_num => var.chart_of_accounts_id,
1159: p_qualifier => 'GL_ACCOUNT',

Line 1162: var.natacct_desc := substrb(fa_rx_flex_pkg.get_description(

1158: p_id_flex_num => var.chart_of_accounts_id,
1159: p_qualifier => 'GL_ACCOUNT',
1160: p_ccid => var.ccid2);*/
1161:
1162: var.natacct_desc := substrb(fa_rx_flex_pkg.get_description(
1163: p_application_id => 101,
1164: p_id_flex_code => 'GL#',
1165: p_id_flex_num => var.chart_of_accounts_id,
1166: p_qualifier => 'GL_ACCOUNT',

Line 1514: get_item := fa_rx_flex_pkg.flex_sql(

1510: oe_profile.get(
1511: name => 'SO_ORGANIZATION_ID',
1512: val => var.so_organization_id);
1513:
1514: get_item := fa_rx_flex_pkg.flex_sql(
1515: p_application_id => 401,
1516: p_id_flex_code => var.so_id_flex_code,
1517: p_id_flex_num => null,
1518: p_table_alias => 'ITEM',

Line 1529: FA_RX_FLEX_PKG.FLEX_SQL(

1525: --
1526: -- Flex SQL for Select columns
1527: --
1528: CC_ACCOUNT_SEL :=
1529: FA_RX_FLEX_PKG.FLEX_SQL(
1530: p_application_id => 101,
1531: p_id_flex_code => 'GL#',
1532: p_id_flex_num => var.chart_of_accounts_id,
1533: p_table_alias => 'CCDIST',

Line 1537: FA_RX_FLEX_PKG.FLEX_SQL(

1533: p_table_alias => 'CCDIST',
1534: p_mode => 'SELECT',
1535: p_qualifier => 'ALL');
1536: CC_BALANCE_SEL :=
1537: FA_RX_FLEX_PKG.FLEX_SQL(
1538: p_application_id => 101,
1539: p_id_flex_code => 'GL#',
1540: p_id_flex_num => var.chart_of_accounts_id,
1541: p_table_alias => 'CCDIST',

Line 1545: FA_RX_FLEX_PKG.FLEX_SQL(

1541: p_table_alias => 'CCDIST',
1542: p_mode => 'SELECT',
1543: p_qualifier => 'GL_BALANCING');
1544: CC_NATURAL_SEL :=
1545: FA_RX_FLEX_PKG.FLEX_SQL(
1546: p_application_id => 101,
1547: p_id_flex_code => 'GL#',
1548: p_id_flex_num => var.chart_of_accounts_id,
1549: p_table_alias => 'CCDIST',

Line 1570: natural_account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(

1566: -- Receivables Natural Account parameters
1567: if (var.start_rec_nat_acct is NULL) and (var.end_rec_nat_acct is NULL) then
1568: natural_account_where := NULL;
1569: elsif var.start_rec_nat_acct is NULL then
1570: natural_account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1571: p_application_id => 101,
1572: p_id_flex_code => 'GL#',
1573: p_id_flex_num => var.chart_of_accounts_id,
1574: p_table_alias => 'CCRECDIST',

Line 1580: natural_account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(

1576: p_qualifier => 'GL_ACCOUNT',
1577: P_function => '<=',
1578: p_operand1 => var.end_rec_nat_acct);
1579: elsif var.end_rec_nat_acct is NULL then
1580: natural_account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1581: p_application_id => 101,
1582: p_id_flex_code => 'GL#',
1583: p_id_flex_num => var.chart_of_accounts_id,
1584: p_table_alias => 'CCRECDIST',

Line 1590: natural_account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(

1586: p_qualifier => 'GL_ACCOUNT',
1587: p_function => '>=',
1588: p_operand1 => var.start_rec_nat_acct);
1589: else
1590: natural_account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1591: p_application_id => 101,
1592: p_id_flex_code => 'GL#',
1593: p_id_flex_num => var.chart_of_accounts_id,
1594: p_table_alias => 'CCRECDIST',

Line 1607: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(

1603: if var.line_invoice = 'LINE' then
1604: if (var.start_account is NULL) and (var.end_account is NULL) then
1605: account_where := NULL;
1606: elsif var.start_account is NULL then
1607: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1608: p_application_id => 101,
1609: p_id_flex_code => 'GL#',
1610: p_id_flex_num => var.chart_of_accounts_id,
1611: p_table_alias => 'CCDIST', -- This alias is used in main select statement

Line 1617: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(

1613: p_qualifier => 'ALL',
1614: p_function => '<=',
1615: p_operand1 => var.end_account);
1616: elsif var.end_account is NULL then
1617: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1618: p_application_id => 101,
1619: p_id_flex_code => 'GL#',
1620: p_id_flex_num => var.chart_of_accounts_id,
1621: p_table_alias => 'CCDIST', -- This alias is used in main select statement

Line 1627: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(

1623: p_qualifier => 'ALL',
1624: p_function => '>=',
1625: p_operand1 => var.start_account);
1626: else
1627: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1628: p_application_id => 101,
1629: p_id_flex_code => 'GL#',
1630: p_id_flex_num => var.chart_of_accounts_id,
1631: p_table_alias => 'CCDIST', -- This alias is used in main select statement

Line 1642: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(

1638: else
1639: if (var.start_account is NULL) and (var.end_account is NULL) then
1640: account_where := NULL;
1641: elsif var.start_account is NULL then
1642: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1643: p_application_id => 101,
1644: p_id_flex_code => 'GL#',
1645: p_id_flex_num => var.chart_of_accounts_id,
1646: p_table_alias => 'LINEGL', -- This alias is used in sub query.

Line 1652: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(

1648: p_qualifier => 'ALL',
1649: p_function => '<=',
1650: p_operand1 => var.end_account);
1651: elsif var.end_account is NULL then
1652: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1653: p_application_id => 101,
1654: p_id_flex_code => 'GL#',
1655: p_id_flex_num => var.chart_of_accounts_id,
1656: p_table_alias => 'LINEGL', -- This alias is used in sub query.

Line 1662: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(

1658: p_qualifier => 'ALL',
1659: p_function => '>=',
1660: p_operand1 => var.start_account);
1661: else
1662: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1663: p_application_id => 101,
1664: p_id_flex_code => 'GL#',
1665: p_id_flex_num => var.chart_of_accounts_id,
1666: p_table_alias => 'LINEGL', -- This alias is used in sub query.

Line 1827: var.account_desc := substrb(fa_rx_flex_pkg.get_description(

1823: -- Get FLEX FIELD VALUE and DESCRIPTION
1824: --
1825: fa_rx_util_pkg.debug('AR_GET_FLEX_KEYWORD');
1826:
1827: var.account_desc := substrb(fa_rx_flex_pkg.get_description(
1828: p_application_id => 101,
1829: p_id_flex_code => 'GL#',
1830: p_id_flex_num => var.chart_of_accounts_id,
1831: p_qualifier => 'ALL',

Line 1834: var.balance_desc := substrb(fa_rx_flex_pkg.get_description(

1830: p_id_flex_num => var.chart_of_accounts_id,
1831: p_qualifier => 'ALL',
1832: p_data => var.account), 1, 240);
1833:
1834: var.balance_desc := substrb(fa_rx_flex_pkg.get_description(
1835: p_application_id => 101,
1836: p_id_flex_code => 'GL#',
1837: p_id_flex_num => var.chart_of_accounts_id,
1838: p_qualifier => 'GL_BALANCING',

Line 1841: var.natacct_desc := substrb(fa_rx_flex_pkg.get_description(

1837: p_id_flex_num => var.chart_of_accounts_id,
1838: p_qualifier => 'GL_BALANCING',
1839: p_data => var.balance), 1, 240);
1840:
1841: var.natacct_desc := substrb(fa_rx_flex_pkg.get_description(
1842: p_application_id => 101,
1843: p_id_flex_code => 'GL#',
1844: p_id_flex_num => var.chart_of_accounts_id,
1845: p_qualifier => 'GL_ACCOUNT',