[Home] [Help]
592: oe_order_lines_all sl_parent,
593: oe_order_headers_all sh,
594: ACCNT_CLASS AC,
595: xla_ae_headers aeh,
596: xla_ae_lines ael,
597: xla_distribution_links lnk
598: WHERE fpk.view_type_id= 4
599: AND fpk.job_num = p_job_num
600: AND aeh.ae_header_id = fpk.primary_key1
869: gl_ledgers_public_v sob,
870: hz_cust_accounts bill_acct,
871: ACCNT_CLASS AC,
872: xla_ae_headers aeh,
873: xla_ae_lines ael,
874: xla_distribution_links lnk
875: WHERE fpk.view_type_id = 3
876: AND fpk.job_num = p_job_num
877: -- AND adj.adjustment_id = fpk.Primary_Key1
1168: ra_cust_trx_types_all ctt,
1169: ra_cust_trx_line_gl_dist_all ctlgd,
1170: ACCNT_CLASS AC,
1171: xla_distribution_links lnk,
1172: xla_ae_lines ael,
1173: xla_ae_headers aeh
1174: WHERE fpk.view_type_id= 4
1175: AND fpk.job_num = p_job_num
1176: AND ctl.customer_trx_line_id = fpk.primary_key1
3294: and fslg.usage_code = g_usage_code
3295: ) lidset,
3296: ACCNT_CLASS AC,
3297: xla_distribution_links lnk,
3298: xla_ae_lines ael,
3299: xla_ae_headers aeh
3300: WHERE aeh.accounting_date BETWEEN g_gl_from_date AND g_gl_to_date
3301: AND adj.gl_date BETWEEN g_gl_from_date AND g_gl_to_date
3302: AND NVL(adj.status, 'A') = 'A'
3351: and fslg.usage_code = g_usage_code
3352: ) lidset,
3353: ACCNT_CLASS AC,
3354: xla_distribution_links lnk,
3355: xla_ae_lines ael,
3356: xla_ae_headers aeh
3357: WHERE aeh.accounting_date BETWEEN g_gl_from_date AND g_gl_to_date
3358: AND ctlgd.gl_date BETWEEN g_gl_from_date AND g_gl_to_date
3359: AND ctlgd.account_set_flag = 'N'