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.CST_REVENUECOGSMATCH_PVT dependencies on GL_PERIOD_STATUSES

Line 1594: gl_period_statuses gps,

1590: FROM cst_revenue_cogs_match_lines crcml,
1591: cst_revenue_recognition_lines crrl,
1592: cst_cogs_events cce,
1593: mtl_parameters mp,
1594: gl_period_statuses gps,
1595: cst_lists_temp clt,
1596: mtl_system_items msi
1597: --{BUG#6809034
1598: ,mtl_material_transactions mmt

Line 1668: l_period_name gl_period_statuses.period_name%type;

1664:
1665: l_gl_period_status VARCHAR2(1);
1666: l_alternate_event_date DATE;
1667: l_dummy_date DATE;
1668: l_period_name gl_period_statuses.period_name%type;
1669:
1670: l_last_fetch BOOLEAN;
1671: l_cce_count PLS_INTEGER := 0;
1672:

Line 1832: FROM gl_period_statuses glp

1828: SELECT MAX(glp.effective_period_num)
1829: ,MIN(glp.effective_period_num)
1830: INTO l_max_period_num --l_rev_cogs_period_num
1831: ,l_min_period_num
1832: FROM gl_period_statuses glp
1833: ,cst_revenue_recognition_lines crrl
1834: ,cst_revenue_cogs_match_lines crcml
1835: ,cst_cogs_events cce
1836: WHERE crrl.acct_period_num = l_per_num_tab(j)

Line 1865: FROM gl_period_statuses

1861: adjustment_period_flag --BUG7438582
1862: INTO l_gl_period_status,
1863: l_period_name,
1864: l_gl_adj_flag
1865: FROM gl_period_statuses
1866: WHERE application_id = 101
1867: AND ledger_id = l_sob
1868: AND effective_period_num = l_max_period_num; --l_per_num_tab(j); the period to check is the cogs period
1869:

Line 1890: FROM gl_period_statuses

1886: l_stmt_num := 30;
1887: debug(l_stmt_num);
1888: SELECT min(effective_period_num)
1889: INTO l_cogs_acct_period_num
1890: FROM gl_period_statuses
1891: WHERE application_id = 101
1892: AND ledger_id = l_sob --l_sob.set_of_books_id
1893: AND effective_period_num > l_max_period_num --l_per_num_tab(j)
1894: AND (closing_status = 'O'

Line 1908: FROM gl_period_statuses

1904: l_stmt_num := 40;
1905: debug(l_stmt_num);
1906: SELECT start_date
1907: INTO l_alternate_event_date
1908: FROM gl_period_statuses
1909: WHERE application_id = 101
1910: AND ledger_id = l_sob --l_sob.set_of_books_id
1911: AND effective_period_num = l_cogs_acct_period_num;
1912:

Line 6090: GL_PERIOD_STATUSES GPS,

6086: sum(decode(mta.accounting_line_type, 36, MTA.BASE_TRANSACTION_VALUE,0)) DEF_COGS_BALANCE
6087: FROM
6088: CST_REVENUE_COGS_MATCH_LINES CRCML,
6089: CST_COGS_EVENTS CCE,
6090: GL_PERIOD_STATUSES GPS,
6091: OE_ORDER_LINES_ALL OOL,
6092: OE_ORDER_HEADERS_ALL OOH,
6093: MTL_TRANSACTION_ACCOUNTS MTA
6094: WHERE

Line 6138: GL_PERIOD_STATUSES GPS,

6134: sum(decode(mta.accounting_line_type, 36, MTA.BASE_TRANSACTION_VALUE,0)) DEF_COGS_BALANCE
6135: FROM
6136: CST_REVENUE_COGS_MATCH_LINES CRCML,
6137: CST_COGS_EVENTS CCE,
6138: GL_PERIOD_STATUSES GPS,
6139: OE_ORDER_LINES_ALL OOL,
6140: OE_ORDER_HEADERS_ALL OOH,
6141: MTL_TRANSACTION_ACCOUNTS MTA
6142: WHERE

Line 6244: GL_PERIOD_STATUSES GPS1,

6240: Decode(trx.TRX_NUMBER,Min(lines1.TRX_NUMBER),Decode(Z.INVOICE_LINE,Min(lines1.MIN_INV_LINE),Z.COGS_account,NULL),NULL) cogs_account,
6241: Decode(trx.TRX_NUMBER,Min(lines1.TRX_NUMBER),Decode(Z.INVOICE_LINE,Min(lines1.MIN_INV_LINE),Z.Deferred_COGS_account,NULL),NULL) deferred_cogs_account
6242: FROM
6243: Z,
6244: GL_PERIOD_STATUSES GPS1,
6245: ra_cust_trx_line_gl_dist_all dist,
6246: ra_customer_trx_lines_all lines,
6247: ra_customer_trx_all trx,
6248: (SELECT rctla.INTERFACE_LINE_ATTRIBUTE1,rctla.INTERFACE_LINE_ATTRIBUTE6,rcta.TRX_NUMBER,min(rctla.LINE_NUMBER) MIN_INV_LINE

Line 6374: , gl_period_statuses g2

6370: AND NOT EXISTS
6371: (SELECT NULL
6372: FROM ra_customer_trx_lines_all ctl
6373: , ra_cust_trx_line_gl_dist_all ctlgd
6374: , gl_period_statuses g2
6375: WHERE (Z.customer_trx_line_id = ctl.customer_trx_line_id
6376: OR Z.customer_trx_line_id = ctl.previous_customer_trx_line_id)
6377: AND g2.application_id = 101
6378: AND g2.set_of_books_id = :i_ledger_id

Line 7573: , gl_period_statuses glp

7569: , DECODE(crrl.acct_period_num,latest_rev.mper,'Y',NULL) flag
7570: FROM cst_revenue_recognition_lines CRRL
7571: , cst_revenue_cogs_match_lines crcml
7572: , cst_cogs_events cce
7573: , gl_period_statuses glp
7574: , (SELECT MAX(crrl3.acct_period_num) mper
7575: , crrl3.revenue_om_line_id
7576: FROM cst_revenue_recognition_lines crrl3
7577: WHERE crrl3.potentially_unmatched_flag = 'Y'

Line 7663: FROM gl_period_statuses

7659: IS
7660: CURSOR c IS
7661: SELECT min(effective_period_num) per_num
7662: ,min(start_date) start_date
7663: FROM gl_period_statuses
7664: WHERE application_id = 101
7665: AND ledger_id = p_ledger_id
7666: AND effective_period_num > p_per_num
7667: AND ( closing_status = 'O' OR

Line 7746: FROM gl_period_statuses

7742: ,closing_status
7743: ,effective_period_num
7744: ,start_date
7745: ,'DATE') NUMBER_3
7746: FROM gl_period_statuses
7747: WHERE ledger_id = p_ledger_id
7748: AND application_id = 101
7749: AND EFFECTIVE_PERIOD_NUM >= p_low_per_num
7750: AND EFFECTIVE_PERIOD_NUM <= p_hig_per_num;

Line 7903: , gl_period_statuses glp

7899: ,p_ledger_id IN NUMBER)
7900: IS
7901: SELECT oap.acct_period_id
7902: FROM CST_LISTS_TEMP list
7903: , gl_period_statuses glp
7904: , org_acct_periods oap
7905: WHERE VARCHAR_1 <> 'TIMEZONE'
7906: AND p_date_num BETWEEN
7907: list.NUMBER_1 -- start_date