APPS.CST_REVENUECOGSMATCH_PVT dependencies on GL_PERIOD_STATUSES

Line 1411: gl_period_statuses gps,

1407: FROM cst_revenue_cogs_match_lines crcml,
1408: cst_revenue_recognition_lines crrl,
1409: cst_cogs_events cce,
1410: mtl_parameters mp,
1411: gl_period_statuses gps,
1412: cst_lists_temp clt,
1413: mtl_system_items msi
1414: --{BUG#6809034
1415: ,mtl_material_transactions mmt

Line 1466: l_period_name gl_period_statuses.period_name%type;

1462: l_cogs_acct_period_num NUMBER := NULL;
1463: l_gl_period_status VARCHAR2(1);
1464: l_alternate_event_date DATE;
1465: l_dummy_date DATE;
1466: l_period_name gl_period_statuses.period_name%type;
1467:
1468: l_last_fetch BOOLEAN;
1469: l_cce_count PLS_INTEGER := 0;
1470:

Line 1639: -- gl_period_statuses gps,

1635: -- crrl.ledger_id,
1636: -- crrl.inventory_item_id
1637: -- FROM cst_revenue_cogs_match_lines crcml,
1638: -- cst_lists_temp clt,
1639: -- gl_period_statuses gps,
1640: -- cst_cogs_events cce,
1641: -- cst_revenue_recognition_lines crrl
1642: -- WHERE crcml.pac_cost_type_id IS NULL
1643: -- AND clt.list_id = crcml.organization_id

Line 1758: gl_period_statuses gps

1754: FROM cst_revenue_recognition_lines crrl,
1755: cst_revenue_cogs_match_lines crcml,
1756: cst_cogs_events cce,
1757: cst_lists_temp clt,
1758: gl_period_statuses gps
1759: --{
1760: -- , cst_cogs_events cce2
1761: --}
1762: WHERE crrl.ledger_id = l_sob --l_sob.set_of_books_id

Line 1800: gl_period_statuses gps

1796: FROM cst_revenue_recognition_lines crrl,
1797: cst_revenue_cogs_match_lines crcml,
1798: cst_cogs_events cce,
1799: cst_lists_temp clt,
1800: gl_period_statuses gps
1801: WHERE crrl.ledger_id = l_sob --l_sob.set_of_books_id
1802: AND crrl.potentially_unmatched_flag = 'Y'
1803: AND crrl.request_id = p_neg_req_id --BUG#7387575
1804: AND crrl.revenue_om_line_id = crcml.revenue_om_line_id

Line 1847: FROM gl_period_statuses

1843: adjustment_period_flag --BUG7438582 UTSTAR
1844: INTO l_gl_period_status,
1845: l_period_name,
1846: l_gl_adj_flag --BUG7438582 UTSTAR
1847: FROM gl_period_statuses
1848: WHERE application_id = 101
1849: AND ledger_id = l_sob --l_sob.set_of_books_id
1850: AND effective_period_num = l_revenue_acct_period_num;
1851:

Line 1866: FROM gl_period_statuses

1862: l_stmt_num := 30;
1863: debug(l_stmt_num);
1864: SELECT min(effective_period_num)
1865: INTO l_cogs_acct_period_num
1866: FROM gl_period_statuses
1867: WHERE application_id = 101
1868: AND ledger_id = l_sob --l_sob.set_of_books_id
1869: AND effective_period_num > l_revenue_acct_period_num
1870: AND (closing_status = 'O'

Line 1883: FROM gl_period_statuses

1879: l_stmt_num := 40;
1880: debug(l_stmt_num);
1881: SELECT start_date
1882: INTO l_alternate_event_date
1883: FROM gl_period_statuses
1884: WHERE application_id = 101
1885: AND ledger_id = l_sob --l_sob.set_of_books_id
1886: AND effective_period_num = l_cogs_acct_period_num;
1887: EXCEPTION

Line 5970: GL_PERIOD_STATUSES GPS,

5966: sum(decode(mta.accounting_line_type, 36, MTA.BASE_TRANSACTION_VALUE,0)) DEF_COGS_BALANCE
5967: FROM
5968: CST_REVENUE_COGS_MATCH_LINES CRCML,
5969: CST_COGS_EVENTS CCE,
5970: GL_PERIOD_STATUSES GPS,
5971: OE_ORDER_LINES_ALL OOL,
5972: OE_ORDER_HEADERS_ALL OOH,
5973: MTL_TRANSACTION_ACCOUNTS MTA
5974: WHERE

Line 6055: GL_PERIOD_STATUSES GPS1,

6051: Z.COGS_account cogs_account,
6052: Z.Deferred_COGS_account deferred_cogs_account
6053: FROM
6054: Z,
6055: GL_PERIOD_STATUSES GPS1,
6056: ra_cust_trx_line_gl_dist_all dist,
6057: ra_customer_trx_lines_all lines,
6058: ra_customer_trx_all trx
6059: WHERE (Z.customer_trx_line_id = lines.customer_trx_line_id