[Home] [Help]
1277: oap.acct_period_id -- acct period ID, I should store this in CCE so I don't keep having to go back to OAP
1278: FROM cst_cogs_events cce,
1279: cst_revenue_cogs_match_lines crcml,
1280: mtl_parameters mp,
1281: org_acct_periods oap,
1282: cst_acct_info_v caiv,
1283: mtl_system_items msi
1284: WHERE cce.cogs_om_line_id = l_cogs_om_line_id_tbl(i)
1285: AND TRUNC(cce.event_date) > l_txn_date_tbl(i)
1576: crcml.organization_id organization_id,
1577: crcml.cost_group_id cost_group_id,
1578: nvl(mp.process_enabled_flag,'N') opm_org,
1579: (select oap.acct_period_id
1580: from org_acct_periods oap
1581: where oap.organization_id = crcml.organization_id
1582: and oap.period_name = gps.period_name) acct_period_id,
1583: clt.number_1 date_offset
1584: --{BUG#6809034 use CCE event_date if mmt trx after rev recog
2216: l_cogs_acct_id_tbl(i),
2217: l_opm_org_flg_tbl(i),
2218: oap.acct_period_id
2219: FROM cst_cogs_events cce,
2220: org_acct_periods oap
2221: WHERE cogs_om_line_id = l_cogs_om_line_id_tbl(i)
2222: AND prior_event_id = l_prior_event_id_tbl(i)
2223: AND event_id <> l_new_event_id_tbl(i)
2224: AND cce.event_date
3180: oap.acct_period_id
3181: FROM cst_cogs_events cce,
3182: cst_revenue_cogs_match_lines crcml,
3183: mtl_parameters mp,
3184: org_acct_periods oap,
3185: cst_acct_info_v caiv,
3186: mtl_system_items msi
3187: WHERE cce.cogs_om_line_id = p_cogs_om_line_id
3188: AND cce.event_date > p_transaction_date
6850: ,oap2.acct_period_id
6851: ,oap2.open_flag
6852: ,mmtt.organization_id
6853: FROM mtl_cogs_recognition_temp mmtt,
6854: org_acct_periods oap,
6855: (SELECT period_start_date,
6856: schedule_close_date,
6857: acct_period_id,
6858: organization_id,
6856: schedule_close_date,
6857: acct_period_id,
6858: organization_id,
6859: open_flag
6860: FROM org_acct_periods) oap2
6861: WHERE mmtt.acct_period_id = oap.acct_period_id
6862: AND mmtt.organization_id = oap.organization_id
6863: AND oap2.organization_id = mmtt.organization_id
6864: --
6888: ,p_transaction_date IN DATE)
6889: IS
6890: SELECT MIN(acct_period_id),
6891: MIN(period_start_date)
6892: FROM org_acct_periods
6893: WHERE organization_id = p_organization_id
6894: AND open_flag = 'Y'
6895: AND period_start_date >= p_transaction_date;
6896: l_next_acct_period_id 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
7908: AND list.NUMBER_2 -- end_date