APPS.CST_REVENUECOGSMATCH_PVT dependencies on ORG_ACCT_PERIODS

Line 1103: org_acct_periods oap,

1099: oap.acct_period_id -- acct period ID, I should store this in CCE so I don't keep having to go back to OAP
1100: FROM cst_cogs_events cce,
1101: cst_revenue_cogs_match_lines crcml,
1102: mtl_parameters mp,
1103: org_acct_periods oap,
1104: cst_acct_info_v caiv,
1105: mtl_system_items msi
1106: WHERE cce.cogs_om_line_id = l_cogs_om_line_id_tbl(i)
1107: AND cce.event_date > l_txn_date_tbl(i)

Line 1398: from org_acct_periods oap

1394: crcml.organization_id,
1395: crcml.cost_group_id,
1396: nvl(mp.process_enabled_flag,'N') opm_org,
1397: (select oap.acct_period_id
1398: from org_acct_periods oap
1399: where oap.organization_id = crcml.organization_id
1400: and oap.period_name = gps.period_name) acct_period_id,
1401: clt.number_1 date_offset
1402: --{BUG#6809034 use CCE event_date if mmt trx after rev recog

Line 2171: org_acct_periods oap

2167: l_cogs_acct_id_tbl(i),
2168: l_opm_org_flg_tbl(i),
2169: oap.acct_period_id
2170: FROM cst_cogs_events cce,
2171: org_acct_periods oap
2172: WHERE cogs_om_line_id = l_cogs_om_line_id_tbl(i)
2173: AND prior_event_id = l_prior_event_id_tbl(i)
2174: AND event_id <> l_new_event_id_tbl(i)
2175: AND cce.event_date

Line 3160: org_acct_periods oap,

3156: oap.acct_period_id
3157: FROM cst_cogs_events cce,
3158: cst_revenue_cogs_match_lines crcml,
3159: mtl_parameters mp,
3160: org_acct_periods oap,
3161: cst_acct_info_v caiv,
3162: mtl_system_items msi
3163: WHERE cce.cogs_om_line_id = p_cogs_om_line_id
3164: AND cce.event_date > p_transaction_date

Line 6509: org_acct_periods oap,

6505: ,oap2.acct_period_id
6506: ,oap2.open_flag
6507: ,mmtt.organization_id
6508: FROM mtl_cogs_recognition_temp mmtt,
6509: org_acct_periods oap,
6510: (SELECT period_start_date,
6511: schedule_close_date,
6512: acct_period_id,
6513: organization_id,

Line 6515: FROM org_acct_periods) oap2

6511: schedule_close_date,
6512: acct_period_id,
6513: organization_id,
6514: open_flag
6515: FROM org_acct_periods) oap2
6516: WHERE mmtt.acct_period_id = oap.acct_period_id
6517: AND mmtt.organization_id = oap.organization_id
6518: AND oap2.organization_id = mmtt.organization_id
6519: --

Line 6547: FROM org_acct_periods

6543: ,p_transaction_date IN DATE)
6544: IS
6545: SELECT MIN(acct_period_id),
6546: MIN(period_start_date)
6547: FROM org_acct_periods
6548: WHERE organization_id = p_organization_id
6549: AND open_flag = 'Y'
6550: AND period_start_date >= p_transaction_date;
6551: l_next_acct_period_id NUMBER;