DBA Data[Home] [Help]

APPS.AR_MATCH_REV_COGS_GRP dependencies on GL_DATE_PERIOD_MAP

Line 260: gl_date_period_map gl_map,

256: (partition by l.sales_order,l.org_id
257: order by l.sales_order, l.org_id) rn
258: FROM ra_customer_trx_lines_all l,
259: ra_cust_trx_line_gl_dist_all gld,
260: gl_date_period_map gl_map,
261: gl_sets_of_books gl_sob
262: WHERE gld.cogs_request_id = p_request_id
263: AND gld.org_id = p_org_id
264: AND gld.account_class = 'REV'

Line 291: gl_date_period_map gl_map,

287: Decode(l.interface_line_attribute6, NULL, -96,
288: p_request_id))),-100)) cogs_request_id
289: FROM ra_customer_trx_lines_all l,
290: ra_cust_trx_line_gl_dist_all gld,
291: gl_date_period_map gl_map,
292: gl_sets_of_books gl_sob
293: WHERE gld.cogs_request_id IS NULL
294: AND gld.org_id = p_org_id
295: AND gld.account_class = 'REV'