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 427: FA_RX_FLEX_PKG.FLEX_SQL(

423: ELSE
424: IF var.ca_sob_type = 'P' THEN
425: REC_ACCOUNT_WHERE := ' AND RECDIST.CUSTOMER_TRX_ID in (select RECDIST1.CUSTOMER_TRX_ID from RA_CUST_TRX_LINE_GL_DIST_ALL RECDIST1,GL_CODE_COMBINATIONS CCRECDIST1
426: where CT.CUSTOMER_TRX_ID = RECDIST.CUSTOMER_TRX_ID AND RECDIST1.CODE_COMBINATION_ID = CCRECDIST1.CODE_COMBINATION_ID AND RECDIST1.ACCOUNT_CLASS in (''REV'',''UNEARN'',''UNBILL'') AND '||
427: FA_RX_FLEX_PKG.FLEX_SQL(
428: p_application_id => 101,
429: p_id_flex_code => 'GL#',
430: p_id_flex_num => var.chart_of_accounts_id,
431: p_table_alias => 'CCRECDIST1',

Line 443: FA_RX_FLEX_PKG.FLEX_SQL(

439: else
440:
441: REC_ACCOUNT_WHERE := ' AND RECDIST.CUSTOMER_TRX_ID in (select RECDIST1.CUSTOMER_TRX_ID from RA_TRX_LINE_GL_DIST_ALL_MRC_V RECDIST1,GL_CODE_COMBINATIONS CCRECDIST1
442: where CT.CUSTOMER_TRX_ID = RECDIST.CUSTOMER_TRX_ID AND RECDIST1.CODE_COMBINATION_ID = CCRECDIST1.CODE_COMBINATION_ID AND RECDIST1.ACCOUNT_CLASS in (''REV'',''UNEARN'',''UNBILL'') AND '||
443: FA_RX_FLEX_PKG.FLEX_SQL(
444: p_application_id => 101,
445: p_id_flex_code => 'GL#',
446: p_id_flex_num => var.chart_of_accounts_id,
447: p_table_alias => 'CCRECDIST1',

Line 573: FA_RX_FLEX_PKG.FLEX_SQL(

569: --
570: -- Flex SQL
571: --
572: REC_ACCOUNT_SEL :=
573: FA_RX_FLEX_PKG.FLEX_SQL(
574: p_application_id => 101,
575: p_id_flex_code => 'GL#',
576: p_id_flex_num => var.chart_of_accounts_id,
577: p_table_alias => 'CCRECDIST',

Line 581: FA_RX_FLEX_PKG.FLEX_SQL(

577: p_table_alias => 'CCRECDIST',
578: p_mode => 'SELECT',
579: p_qualifier => 'ALL');
580: REC_BALANCE_SEL :=
581: FA_RX_FLEX_PKG.FLEX_SQL(
582: p_application_id => 101,
583: p_id_flex_code => 'GL#',
584: p_id_flex_num => var.chart_of_accounts_id,
585: p_table_alias => 'CCRECDIST',

Line 589: FA_RX_FLEX_PKG.FLEX_SQL(

585: p_table_alias => 'CCRECDIST',
586: p_mode => 'SELECT',
587: p_qualifier => 'GL_BALANCING');
588: REC_NATURAL_SEL :=
589: FA_RX_FLEX_PKG.FLEX_SQL(
590: p_application_id => 101,
591: p_id_flex_code => 'GL#',
592: p_id_flex_num => var.chart_of_accounts_id,
593: p_table_alias => 'CCRECDIST',

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

828: -- Get FLEX FIELD VALUE and DESCRIPTION
829: --
830: fa_rx_util_pkg.debug('GL_GET_FLEX_KEYWORD');
831:
832: /* var.rec_account := fa_rx_flex_pkg.get_value(
833: p_application_id => 101,
834: p_id_flex_code => 'GL#',
835: p_id_flex_num => var.chart_of_accounts_id,
836: p_qualifier => 'ALL',

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

835: p_id_flex_num => var.chart_of_accounts_id,
836: p_qualifier => 'ALL',
837: p_ccid => var.ccid);*/
838:
839: var.rec_account_desc := substrb(fa_rx_flex_pkg.get_description(
840: p_application_id => 101,
841: p_id_flex_code => 'GL#',
842: p_id_flex_num => var.chart_of_accounts_id,
843: p_qualifier => 'ALL',

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

842: p_id_flex_num => var.chart_of_accounts_id,
843: p_qualifier => 'ALL',
844: p_data => var.rec_account),1,240);
845:
846: /* var.rec_balance := fa_rx_flex_pkg.get_value(
847: p_application_id => 101,
848: p_id_flex_code => 'GL#',
849: p_id_flex_num => var.chart_of_accounts_id,
850: p_qualifier => 'GL_BALANCING',

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

849: p_id_flex_num => var.chart_of_accounts_id,
850: p_qualifier => 'GL_BALANCING',
851: p_ccid => var.ccid);*/
852:
853: var.rec_balance_desc := substrb(fa_rx_flex_pkg.get_description(
854: p_application_id => 101,
855: p_id_flex_code => 'GL#',
856: p_id_flex_num => var.chart_of_accounts_id,
857: p_qualifier => 'GL_BALANCING',

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

856: p_id_flex_num => var.chart_of_accounts_id,
857: p_qualifier => 'GL_BALANCING',
858: p_data => var.rec_balance),1,240);
859:
860: /* var.rec_natacct := fa_rx_flex_pkg.get_value(
861: p_application_id => 101,
862: p_id_flex_code => 'GL#',
863: p_id_flex_num => var.chart_of_accounts_id,
864: p_qualifier => 'GL_ACCOUNT',

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

863: p_id_flex_num => var.chart_of_accounts_id,
864: p_qualifier => 'GL_ACCOUNT',
865: p_ccid => var.ccid);*/
866:
867: var.rec_natacct_desc := substrb(fa_rx_flex_pkg.get_description(
868: p_application_id => 101,
869: p_id_flex_code => 'GL#',
870: p_id_flex_num => var.chart_of_accounts_id,
871: p_qualifier => 'GL_ACCOUNT',

Line 1024: get_item := fa_rx_flex_pkg.flex_sql(

1020: oe_profile.get(
1021: name => 'SO_ORGANIZATION_ID',
1022: val => var.so_organization_id);
1023:
1024: get_item := fa_rx_flex_pkg.flex_sql(
1025: p_application_id => 401,
1026: p_id_flex_code => var.so_id_flex_code,
1027: p_id_flex_num => null,
1028: p_table_alias => 'ITEM',

Line 1039: FA_RX_FLEX_PKG.FLEX_SQL(

1035: --
1036: -- Flex SQL
1037: --
1038: CC_ACCOUNT_SEL :=
1039: FA_RX_FLEX_PKG.FLEX_SQL(
1040: p_application_id => 101,
1041: p_id_flex_code => 'GL#',
1042: p_id_flex_num => var.chart_of_accounts_id,
1043: p_table_alias => 'CCDIST',

Line 1047: FA_RX_FLEX_PKG.FLEX_SQL(

1043: p_table_alias => 'CCDIST',
1044: p_mode => 'SELECT',
1045: p_qualifier => 'ALL');
1046: CC_BALANCE_SEL :=
1047: FA_RX_FLEX_PKG.FLEX_SQL(
1048: p_application_id => 101,
1049: p_id_flex_code => 'GL#',
1050: p_id_flex_num => var.chart_of_accounts_id,
1051: p_table_alias => 'CCDIST',

Line 1055: FA_RX_FLEX_PKG.FLEX_SQL(

1051: p_table_alias => 'CCDIST',
1052: p_mode => 'SELECT',
1053: p_qualifier => 'GL_BALANCING');
1054: CC_NATURAL_SEL :=
1055: FA_RX_FLEX_PKG.FLEX_SQL(
1056: p_application_id => 101,
1057: p_id_flex_code => 'GL#',
1058: p_id_flex_num => var.chart_of_accounts_id,
1059: p_table_alias => 'CCDIST',

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

1141: -- Get FLEX FIELD VALUE and DESCRIPTION
1142: --
1143: fa_rx_util_pkg.debug('AR_GET_FLEX_KEYWORD');
1144:
1145: /* var.account := fa_rx_flex_pkg.get_value(
1146: p_application_id => 101,
1147: p_id_flex_code => 'GL#',
1148: p_id_flex_num => var.chart_of_accounts_id,
1149: p_qualifier => 'ALL',

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

1148: p_id_flex_num => var.chart_of_accounts_id,
1149: p_qualifier => 'ALL',
1150: p_ccid => var.ccid2);*/
1151:
1152: var.account_desc := substrb(fa_rx_flex_pkg.get_description(
1153: p_application_id => 101,
1154: p_id_flex_code => 'GL#',
1155: p_id_flex_num => var.chart_of_accounts_id,
1156: p_qualifier => 'ALL',

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

1155: p_id_flex_num => var.chart_of_accounts_id,
1156: p_qualifier => 'ALL',
1157: p_data => var.account), 1, 240);
1158:
1159: /* var.balance := fa_rx_flex_pkg.get_value(
1160: p_application_id => 101,
1161: p_id_flex_code => 'GL#',
1162: p_id_flex_num => var.chart_of_accounts_id,
1163: p_qualifier => 'GL_BALANCING',

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

1162: p_id_flex_num => var.chart_of_accounts_id,
1163: p_qualifier => 'GL_BALANCING',
1164: p_ccid => var.ccid2);*/
1165:
1166: var.balance_desc := substrb(fa_rx_flex_pkg.get_description(
1167: p_application_id => 101,
1168: p_id_flex_code => 'GL#',
1169: p_id_flex_num => var.chart_of_accounts_id,
1170: p_qualifier => 'GL_BALANCING',

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

1169: p_id_flex_num => var.chart_of_accounts_id,
1170: p_qualifier => 'GL_BALANCING',
1171: p_data => var.balance), 1, 240);
1172:
1173: /* var.natacct := fa_rx_flex_pkg.get_value(
1174: p_application_id => 101,
1175: p_id_flex_code => 'GL#',
1176: p_id_flex_num => var.chart_of_accounts_id,
1177: p_qualifier => 'GL_ACCOUNT',

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

1176: p_id_flex_num => var.chart_of_accounts_id,
1177: p_qualifier => 'GL_ACCOUNT',
1178: p_ccid => var.ccid2);*/
1179:
1180: var.natacct_desc := substrb(fa_rx_flex_pkg.get_description(
1181: p_application_id => 101,
1182: p_id_flex_code => 'GL#',
1183: p_id_flex_num => var.chart_of_accounts_id,
1184: p_qualifier => 'GL_ACCOUNT',

Line 1532: get_item := fa_rx_flex_pkg.flex_sql(

1528: oe_profile.get(
1529: name => 'SO_ORGANIZATION_ID',
1530: val => var.so_organization_id);
1531:
1532: get_item := fa_rx_flex_pkg.flex_sql(
1533: p_application_id => 401,
1534: p_id_flex_code => var.so_id_flex_code,
1535: p_id_flex_num => null,
1536: p_table_alias => 'ITEM',

Line 1547: FA_RX_FLEX_PKG.FLEX_SQL(

1543: --
1544: -- Flex SQL for Select columns
1545: --
1546: CC_ACCOUNT_SEL :=
1547: FA_RX_FLEX_PKG.FLEX_SQL(
1548: p_application_id => 101,
1549: p_id_flex_code => 'GL#',
1550: p_id_flex_num => var.chart_of_accounts_id,
1551: p_table_alias => 'CCDIST',

Line 1555: FA_RX_FLEX_PKG.FLEX_SQL(

1551: p_table_alias => 'CCDIST',
1552: p_mode => 'SELECT',
1553: p_qualifier => 'ALL');
1554: CC_BALANCE_SEL :=
1555: FA_RX_FLEX_PKG.FLEX_SQL(
1556: p_application_id => 101,
1557: p_id_flex_code => 'GL#',
1558: p_id_flex_num => var.chart_of_accounts_id,
1559: p_table_alias => 'CCDIST',

Line 1563: FA_RX_FLEX_PKG.FLEX_SQL(

1559: p_table_alias => 'CCDIST',
1560: p_mode => 'SELECT',
1561: p_qualifier => 'GL_BALANCING');
1562: CC_NATURAL_SEL :=
1563: FA_RX_FLEX_PKG.FLEX_SQL(
1564: p_application_id => 101,
1565: p_id_flex_code => 'GL#',
1566: p_id_flex_num => var.chart_of_accounts_id,
1567: p_table_alias => 'CCDIST',

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

1584: -- Receivables Natural Account parameters
1585: if (var.start_rec_nat_acct is NULL) and (var.end_rec_nat_acct is NULL) then
1586: natural_account_where := NULL;
1587: elsif var.start_rec_nat_acct is NULL then
1588: natural_account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1589: p_application_id => 101,
1590: p_id_flex_code => 'GL#',
1591: p_id_flex_num => var.chart_of_accounts_id,
1592: p_table_alias => 'CCRECDIST',

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

1594: p_qualifier => 'GL_ACCOUNT',
1595: P_function => '<=',
1596: p_operand1 => var.end_rec_nat_acct);
1597: elsif var.end_rec_nat_acct is NULL then
1598: natural_account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1599: p_application_id => 101,
1600: p_id_flex_code => 'GL#',
1601: p_id_flex_num => var.chart_of_accounts_id,
1602: p_table_alias => 'CCRECDIST',

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

1604: p_qualifier => 'GL_ACCOUNT',
1605: p_function => '>=',
1606: p_operand1 => var.start_rec_nat_acct);
1607: else
1608: natural_account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1609: p_application_id => 101,
1610: p_id_flex_code => 'GL#',
1611: p_id_flex_num => var.chart_of_accounts_id,
1612: p_table_alias => 'CCRECDIST',

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

1621: if var.line_invoice = 'LINE' then
1622: if (var.start_account is NULL) and (var.end_account is NULL) then
1623: account_where := NULL;
1624: elsif var.start_account is NULL then
1625: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1626: p_application_id => 101,
1627: p_id_flex_code => 'GL#',
1628: p_id_flex_num => var.chart_of_accounts_id,
1629: p_table_alias => 'CCDIST', -- This alias is used in main select statement

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

1631: p_qualifier => 'ALL',
1632: p_function => '<=',
1633: p_operand1 => var.end_account);
1634: elsif var.end_account is NULL then
1635: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1636: p_application_id => 101,
1637: p_id_flex_code => 'GL#',
1638: p_id_flex_num => var.chart_of_accounts_id,
1639: p_table_alias => 'CCDIST', -- This alias is used in main select statement

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

1641: p_qualifier => 'ALL',
1642: p_function => '>=',
1643: p_operand1 => var.start_account);
1644: else
1645: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1646: p_application_id => 101,
1647: p_id_flex_code => 'GL#',
1648: p_id_flex_num => var.chart_of_accounts_id,
1649: p_table_alias => 'CCDIST', -- This alias is used in main select statement

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

1656: else
1657: if (var.start_account is NULL) and (var.end_account is NULL) then
1658: account_where := NULL;
1659: elsif var.start_account is NULL then
1660: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1661: p_application_id => 101,
1662: p_id_flex_code => 'GL#',
1663: p_id_flex_num => var.chart_of_accounts_id,
1664: p_table_alias => 'LINEGL', -- This alias is used in sub query.

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

1666: p_qualifier => 'ALL',
1667: p_function => '<=',
1668: p_operand1 => var.end_account);
1669: elsif var.end_account is NULL then
1670: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1671: p_application_id => 101,
1672: p_id_flex_code => 'GL#',
1673: p_id_flex_num => var.chart_of_accounts_id,
1674: p_table_alias => 'LINEGL', -- This alias is used in sub query.

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

1676: p_qualifier => 'ALL',
1677: p_function => '>=',
1678: p_operand1 => var.start_account);
1679: else
1680: account_where := ' AND '|| FA_RX_FLEX_PKG.FLEX_SQL(
1681: p_application_id => 101,
1682: p_id_flex_code => 'GL#',
1683: p_id_flex_num => var.chart_of_accounts_id,
1684: p_table_alias => 'LINEGL', -- This alias is used in sub query.

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

1841: -- Get FLEX FIELD VALUE and DESCRIPTION
1842: --
1843: fa_rx_util_pkg.debug('AR_GET_FLEX_KEYWORD');
1844:
1845: var.account_desc := substrb(fa_rx_flex_pkg.get_description(
1846: p_application_id => 101,
1847: p_id_flex_code => 'GL#',
1848: p_id_flex_num => var.chart_of_accounts_id,
1849: p_qualifier => 'ALL',

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

1848: p_id_flex_num => var.chart_of_accounts_id,
1849: p_qualifier => 'ALL',
1850: p_data => var.account), 1, 240);
1851:
1852: var.balance_desc := substrb(fa_rx_flex_pkg.get_description(
1853: p_application_id => 101,
1854: p_id_flex_code => 'GL#',
1855: p_id_flex_num => var.chart_of_accounts_id,
1856: p_qualifier => 'GL_BALANCING',

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

1855: p_id_flex_num => var.chart_of_accounts_id,
1856: p_qualifier => 'GL_BALANCING',
1857: p_data => var.balance), 1, 240);
1858:
1859: var.natacct_desc := substrb(fa_rx_flex_pkg.get_description(
1860: p_application_id => 101,
1861: p_id_flex_code => 'GL#',
1862: p_id_flex_num => var.chart_of_accounts_id,
1863: p_qualifier => 'GL_ACCOUNT',