[Home] [Help]
1949: | DESCRIPTION
1950: | This procedure is the AP SLA post-processing procedure. This procedure
1951: | will be called by SLA thorugh an API.
1952: |
1953: | The XLA_POST_ACCTG_EVENTS_V view contains only the successfully accounted
1954: | events.
1955: |
1956: | PRAMETERS
1957: | p_application_id
2071: ---------------------------------------------------------------------
2072: FOR i in (SELECT DISTINCT process_category
2073: FROM gmf_xla_event_model em
2074: WHERE exists (SELECT 'X'
2075: FROM xla_post_acctg_events_v ae
2076: WHERE ae.event_class_code = em.event_class_code)
2077: )
2078: LOOP
2079:
2219: in (SELECT
2220: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
2221: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
2222: FROM
2223: xla_post_acctg_events_v xpae,
2224: gmf_xla_event_model gxem
2225: WHERE
2226: gxem.process_category = G_inventory_transactions
2227: and xpae.event_class_code = gxem.event_class_code
2269: in (SELECT
2270: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
2271: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
2272: FROM
2273: xla_post_acctg_events_v xpae,
2274: gmf_xla_event_model gxem
2275: WHERE
2276: gxem.process_category = G_inventory_transactions
2277: and xpae.event_class_code = gxem.event_class_code
2316: WHERE transaction_id
2317: IN (SELECT
2318: xpae.SOURCE_ID_INT_1
2319: FROM
2320: xla_post_acctg_events_v xpae,
2321: gmf_xla_event_model gxem
2322: WHERE
2323: gxem.process_category = G_inventory_transactions
2324: AND xpae.event_class_code = gxem.event_class_code
2374: AND transfer_transaction_id
2375: in (SELECT
2376: xpae.SOURCE_ID_INT_1
2377: FROM
2378: xla_post_acctg_events_v xpae,
2379: gmf_xla_event_model gxem
2380: WHERE
2381: gxem.process_category = G_inventory_transactions
2382: AND xpae.event_class_code = gxem.event_class_code
2426: AND transaction_id
2427: in (SELECT
2428: xpae.SOURCE_ID_INT_1
2429: FROM
2430: xla_post_acctg_events_v xpae,
2431: gmf_xla_event_model gxem
2432: WHERE
2433: gxem.process_category = G_inventory_transactions
2434: AND xpae.event_class_code = gxem.event_class_code
2558: in (SELECT
2559: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
2560: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
2561: FROM
2562: xla_post_acctg_events_v xpae,
2563: gmf_xla_event_model gxem
2564: WHERE
2565: gxem.process_category = G_purchasing_transactions
2566: and xpae.event_class_code = gxem.event_class_code
2608: in (SELECT
2609: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
2610: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
2611: FROM
2612: xla_post_acctg_events_v xpae,
2613: gmf_xla_event_model gxem
2614: WHERE
2615: gxem.process_category = G_purchasing_transactions
2616: and xpae.event_class_code = gxem.event_class_code
2656: WHERE transaction_id
2657: in (SELECT
2658: xpae.SOURCE_ID_INT_1
2659: FROM
2660: xla_post_acctg_events_v xpae,
2661: gmf_xla_event_model gxem
2662: WHERE
2663: gxem.process_category = G_purchasing_transactions
2664: and xpae.event_class_code = gxem.event_class_code
2702: WHERE accounting_txn_id
2703: in (SELECT
2704: xpae.SOURCE_ID_INT_1
2705: FROM
2706: xla_post_acctg_events_v xpae,
2707: gmf_xla_event_model gxem
2708: WHERE
2709: gxem.process_category = G_purchasing_transactions
2710: and gxem.transaction_type IN ('RECEIVING_RECEIVE','RECEIVING_DELIVER_EXPENSE',
2752: ,program_id = g_program_id
2753: ,request_id = g_request_id
2754: WHERE distribution_id
2755: IN (SELECT xpae.SOURCE_ID_INT_1
2756: FROM xla_post_acctg_events_v xpae,
2757: gmf_xla_event_model gxem
2758: WHERE gxem.process_category = G_purchasing_transactions
2759: AND gxem.transaction_type IN ('PAYABLES_INVOICE_IPV_ADJ','PAYABLES_INVOICE_ERV_ADJ')
2760: AND xpae.event_class_code = gxem.event_class_code
2877: in (SELECT
2878: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
2879: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
2880: FROM
2881: xla_post_acctg_events_v xpae,
2882: gmf_xla_event_model gxem
2883: WHERE
2884: gxem.process_category = G_production_transactions
2885: and xpae.event_class_code = gxem.event_class_code
2927: in (SELECT
2928: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
2929: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
2930: FROM
2931: xla_post_acctg_events_v xpae,
2932: gmf_xla_event_model gxem
2933: WHERE
2934: gxem.process_category = G_production_transactions
2935: and xpae.event_class_code = gxem.event_class_code
2975: WHERE transaction_id
2976: in (SELECT
2977: xpae.SOURCE_ID_INT_1
2978: FROM
2979: xla_post_acctg_events_v xpae,
2980: gmf_xla_event_model gxem
2981: WHERE
2982: gxem.process_category = G_production_transactions
2983: and gxem.event_class_code = G_batch_material
3024: WHERE (mmt_transaction_id)
3025: in (SELECT
3026: xpae.SOURCE_ID_INT_1
3027: FROM
3028: xla_post_acctg_events_v xpae,
3029: gmf_xla_event_model gxem
3030: WHERE
3031: gxem.process_category = G_production_transactions
3032: and xpae.event_class_code = gxem.event_class_code
3077: WHERE poc_trans_id
3078: in (SELECT
3079: xpae.SOURCE_ID_INT_1
3080: FROM
3081: xla_post_acctg_events_v xpae,
3082: gmf_xla_event_model gxem
3083: WHERE
3084: gxem.process_category = G_production_transactions
3085: and gxem.event_class_code = G_batch_resource
3123: WHERE batch_id
3124: in (SELECT
3125: xpae.SOURCE_ID_INT_1
3126: FROM
3127: xla_post_acctg_events_v xpae,
3128: gmf_xla_event_model gxem
3129: WHERE
3130: gxem.process_category = G_production_transactions
3131: and gxem.event_class_code = g_batch_close
3250: in (SELECT
3251: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
3252: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
3253: FROM
3254: xla_post_acctg_events_v xpae,
3255: gmf_xla_event_model gxem
3256: WHERE
3257: gxem.process_category = G_order_management
3258: and xpae.event_class_code = gxem.event_class_code
3300: in (SELECT
3301: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
3302: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
3303: FROM
3304: xla_post_acctg_events_v xpae,
3305: gmf_xla_event_model gxem
3306: WHERE
3307: gxem.process_category = G_order_management
3308: and xpae.event_class_code = gxem.event_class_code
3348: WHERE transaction_id
3349: in (SELECT
3350: xpae.SOURCE_ID_INT_1
3351: FROM
3352: xla_post_acctg_events_v xpae,
3353: gmf_xla_event_model gxem
3354: WHERE
3355: gxem.process_category = G_order_management
3356: and xpae.event_class_code = gxem.event_class_code
3397: , request_id = g_request_id
3398: WHERE
3399: exists (SELECT 'x'
3400: FROM
3401: xla_post_acctg_events_v xpae,
3402: gmf_xla_event_model gxem,
3403: gmf_xla_extract_headers eh
3404: WHERE
3405: eh.transaction_id = xpae.SOURCE_ID_INT_1
3540: in (SELECT
3541: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
3542: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
3543: FROM
3544: xla_post_acctg_events_v xpae,
3545: gmf_xla_event_model gxem
3546: WHERE
3547: gxem.process_category = G_revaluation_transactions
3548: and xpae.event_class_code = gxem.event_class_code
3590: in (SELECT
3591: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
3592: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
3593: FROM
3594: xla_post_acctg_events_v xpae,
3595: gmf_xla_event_model gxem
3596: WHERE
3597: gxem.process_category = G_revaluation_transactions
3598: and xpae.event_class_code = gxem.event_class_code
3633: WHERE transaction_id
3634: in (SELECT
3635: xpae.SOURCE_ID_INT_1
3636: FROM
3637: xla_post_acctg_events_v xpae,
3638: gmf_xla_event_model gxem
3639: WHERE
3640: gxem.process_category = G_revaluation_transactions
3641: and xpae.event_class_code = gxem.event_class_code
3658: SELECT cost_type
3659: INTO l_cost_method_type
3660: FROM cm_mthd_mst
3661: WHERE cost_type_id = (SELECT xpae.SOURCE_ID_INT_3
3662: FROM xla_post_acctg_events_v xpae
3663: WHERE rownum = 1)
3664: ;
3665:
3666: --
3697: WHERE adjustment_id
3698: in (SELECT
3699: xpae.SOURCE_ID_INT_1
3700: FROM
3701: xla_post_acctg_events_v xpae,
3702: gmf_xla_event_model gxem
3703: WHERE
3704: gxem.process_category = G_revaluation_transactions
3705: and gxem.transaction_type = 'LOT_COST_ADJUSTMENTS' /* Bug#5597804 ANTHIYAG 06-Nov-2006 */
3748: WHERE period_balance_id
3749: in (SELECT
3750: xpae.SOURCE_ID_INT_1
3751: FROM
3752: xla_post_acctg_events_v xpae,
3753: gmf_xla_event_model gxem
3754: WHERE
3755: gxem.process_category = G_revaluation_transactions
3756: and gxem.transaction_type = 'COST_REVALUATIONS' /*changed LOT_COST_ADJUSTMENTS to COST_REVALUATIONS jboppana*/
3795: WHERE cost_adjust_id
3796: in (SELECT
3797: xpae.SOURCE_ID_INT_1
3798: FROM
3799: xla_post_acctg_events_v xpae,
3800: gmf_xla_event_model gxem
3801: WHERE
3802: gxem.process_category = G_revaluation_transactions
3803: and gxem.transaction_type = 'ACTUAL_COST_ADJUSTMENTS'
3846: WHERE allocdtl_id
3847: in (SELECT
3848: xpae.SOURCE_ID_INT_1
3849: FROM
3850: xla_post_acctg_events_v xpae,
3851: gmf_xla_event_model gxem
3852: WHERE
3853: gxem.process_category = G_revaluation_transactions
3854: and gxem.transaction_type = 'GL_COST_ALLOCATIONS'