[Home] [Help]
2176: | DESCRIPTION
2177: | This procedure is the AP SLA post-processing procedure. This procedure
2178: | will be called by SLA thorugh an API.
2179: |
2180: | The XLA_POST_ACCTG_EVENTS_V view contains only the successfully accounted
2181: | events.
2182: |
2183: | PRAMETERS
2184: | p_application_id
2297: ---------------------------------------------------------------------
2298: FOR i in (SELECT DISTINCT process_category
2299: FROM gmf_xla_event_model em
2300: WHERE exists (SELECT 'X'
2301: FROM xla_post_acctg_events_v ae
2302: WHERE ae.event_class_code = em.event_class_code)
2303: )
2304: LOOP
2305:
2447: in (SELECT
2448: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
2449: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
2450: FROM
2451: xla_post_acctg_events_v xpae,
2452: gmf_xla_event_model gxem
2453: WHERE
2454: gxem.process_category = G_inventory_transactions
2455: and xpae.event_class_code = gxem.event_class_code
2497: in (SELECT
2498: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
2499: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
2500: FROM
2501: xla_post_acctg_events_v xpae,
2502: gmf_xla_event_model gxem
2503: WHERE
2504: gxem.process_category = G_inventory_transactions
2505: and xpae.event_class_code = gxem.event_class_code
2547: WHERE transaction_id
2548: IN (SELECT
2549: xpae.SOURCE_ID_INT_1
2550: FROM
2551: xla_post_acctg_events_v xpae,
2552: gmf_xla_event_model gxem
2553: WHERE
2554: gxem.process_category = G_inventory_transactions
2555: AND xpae.event_class_code = gxem.event_class_code
2568: AND transfer_transaction_id
2569: in (SELECT
2570: xpae.SOURCE_ID_INT_1
2571: FROM
2572: xla_post_acctg_events_v xpae,
2573: gmf_xla_event_model gxem
2574: WHERE
2575: gxem.process_category = G_inventory_transactions
2576: AND xpae.event_class_code = gxem.event_class_code
2589: AND transaction_id
2590: in (SELECT
2591: xpae.SOURCE_ID_INT_1
2592: FROM
2593: xla_post_acctg_events_v xpae,
2594: gmf_xla_event_model gxem
2595: WHERE
2596: gxem.process_category = G_inventory_transactions
2597: AND xpae.event_class_code = gxem.event_class_code
2609: Insert into gmf_inv_Txn_flags_gt (transaction_id, opm_costed_flag, shipment_costed)
2610: SELECT DISTINCT xpae.SOURCE_ID_INT_1 transaction_id,
2611: DECODE(G_accounting_mode, 'D', 'D', 'F', NULL) opm_costed_flag,
2612: NULL shipment_costed
2613: FROM xla_post_acctg_events_v xpae,
2614: gmf_xla_event_model gxem
2615: WHERE gxem.process_category = G_inventory_transactions
2616: AND xpae.event_class_code = gxem.event_class_code
2617: AND xpae.event_class_code NOT IN ('FOB_RCPT_SENDER_RCPT', 'FOB_SHIP_RECIPIENT_SHIP')
2622: AND mmt1.transaction_source_type_id in (2, 4, 8, 9, 10, 13)
2623: AND mmt1.transaction_action_id in (2, 28)
2624: AND mmt1.transaction_id IN
2625: (SELECT xpae.SOURCE_ID_INT_1
2626: FROM xla_post_acctg_events_v xpae,
2627: gmf_xla_event_model gxem
2628: WHERE gxem.process_category = G_inventory_transactions
2629: AND xpae.event_class_code = gxem.event_class_code
2630: AND xpae.event_class_code in ('SUBINV_XFER')
2636: AND mmt2.transaction_source_type_id in (7, 8, 13)
2637: AND mmt2.transaction_action_id in (12, 21)
2638: AND mmt2.transaction_id IN
2639: (SELECT xpae.SOURCE_ID_INT_1
2640: FROM xla_post_acctg_events_v xpae,
2641: gmf_xla_event_model gxem
2642: WHERE gxem.process_category = G_inventory_transactions
2643: AND xpae.event_class_code = gxem.event_class_code
2644: AND xpae.event_class_code in ('FOB_RCPT_SENDER_RCPT', 'FOB_SHIP_RECIPIENT_SHIP'))
2833: in (SELECT
2834: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
2835: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
2836: FROM
2837: xla_post_acctg_events_v xpae,
2838: gmf_xla_event_model gxem
2839: WHERE
2840: gxem.process_category = G_purchasing_transactions
2841: and xpae.event_class_code = gxem.event_class_code
2883: in (SELECT
2884: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
2885: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
2886: FROM
2887: xla_post_acctg_events_v xpae,
2888: gmf_xla_event_model gxem
2889: WHERE
2890: gxem.process_category = G_purchasing_transactions
2891: and xpae.event_class_code = gxem.event_class_code
2932: WHERE transaction_id
2933: in (SELECT
2934: xpae.SOURCE_ID_INT_1
2935: FROM
2936: xla_post_acctg_events_v xpae,
2937: gmf_xla_event_model gxem
2938: WHERE
2939: gxem.process_category = G_purchasing_transactions
2940: and xpae.event_class_code = gxem.event_class_code
2980: WHERE accounting_txn_id
2981: in (SELECT
2982: xpae.SOURCE_ID_INT_1
2983: FROM
2984: xla_post_acctg_events_v xpae,
2985: gmf_xla_event_model gxem
2986: WHERE
2987: gxem.process_category = G_purchasing_transactions
2988: and gxem.transaction_type IN ('RECEIVING_RECEIVE','RECEIVING_DELIVER_EXPENSE',
3030: ,program_id = g_program_id
3031: ,request_id = g_request_id
3032: WHERE distribution_id
3033: IN (SELECT xpae.SOURCE_ID_INT_1
3034: FROM xla_post_acctg_events_v xpae,
3035: gmf_xla_event_model gxem
3036: WHERE gxem.process_category = G_purchasing_transactions
3037: AND gxem.transaction_type IN ('PAYABLES_INVOICE_IPV_ADJ','PAYABLES_INVOICE_ERV_ADJ')
3038: AND xpae.event_class_code = gxem.event_class_code
3076: ,program_id = g_program_id
3077: ,request_id = g_request_id
3078: WHERE adj_transaction_id
3079: IN (SELECT xpae.SOURCE_ID_INT_1
3080: FROM xla_post_acctg_events_v xpae,
3081: gmf_xla_event_model gxem
3082: WHERE gxem.process_category = G_purchasing_transactions
3083: AND gxem.transaction_type IN ('LC_ADJUSTMENT_EXP_DELIVER','LC_ADJUSTMENT_DELIVER','LC_ADJUSTMENT_RECEIVE')
3084: AND xpae.event_class_code = gxem.event_class_code
3116: ,program_id = g_program_id
3117: ,request_id = g_request_id
3118: WHERE adj_transaction_id
3119: IN (SELECT xpae.SOURCE_ID_INT_1
3120: FROM xla_post_acctg_events_v xpae,
3121: gmf_xla_event_model gxem
3122: WHERE gxem.process_category = G_purchasing_transactions
3123: AND gxem.transaction_type IN ('LC_ADJUSTMENT_VALUATION')
3124: AND xpae.event_class_code = gxem.event_class_code
3155: ,program_id = g_program_id
3156: ,request_id = g_request_id
3157: WHERE adj_transaction_id
3158: IN (SELECT xpae.SOURCE_ID_INT_1
3159: FROM xla_post_acctg_events_v xpae,
3160: gmf_xla_event_model gxem
3161: WHERE gxem.process_category = G_purchasing_transactions
3162: AND gxem.transaction_type IN ('LC_ADJUSTMENT_VALUATION')
3163: AND xpae.event_class_code = gxem.event_class_code
3278: in (SELECT
3279: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
3280: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
3281: FROM
3282: xla_post_acctg_events_v xpae,
3283: gmf_xla_event_model gxem
3284: WHERE
3285: gxem.process_category = G_production_transactions
3286: and xpae.event_class_code = gxem.event_class_code
3328: in (SELECT
3329: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
3330: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
3331: FROM
3332: xla_post_acctg_events_v xpae,
3333: gmf_xla_event_model gxem
3334: WHERE
3335: gxem.process_category = G_production_transactions
3336: and xpae.event_class_code = gxem.event_class_code
3377: WHERE transaction_id
3378: in (SELECT
3379: xpae.SOURCE_ID_INT_1
3380: FROM
3381: xla_post_acctg_events_v xpae,
3382: gmf_xla_event_model gxem
3383: WHERE
3384: gxem.process_category = G_production_transactions
3385: and gxem.event_class_code = G_batch_material
3426: WHERE (mmt_transaction_id)
3427: in (SELECT
3428: xpae.SOURCE_ID_INT_1
3429: FROM
3430: xla_post_acctg_events_v xpae,
3431: gmf_xla_event_model gxem
3432: WHERE
3433: gxem.process_category = G_production_transactions
3434: and xpae.event_class_code = gxem.event_class_code
3479: WHERE poc_trans_id
3480: in (SELECT
3481: xpae.SOURCE_ID_INT_1
3482: FROM
3483: xla_post_acctg_events_v xpae,
3484: gmf_xla_event_model gxem
3485: WHERE
3486: gxem.process_category = G_production_transactions
3487: and gxem.event_class_code = G_batch_resource
3525: WHERE batch_id
3526: in (SELECT
3527: xpae.SOURCE_ID_INT_1
3528: FROM
3529: xla_post_acctg_events_v xpae,
3530: gmf_xla_event_model gxem
3531: WHERE
3532: gxem.process_category = G_production_transactions
3533: and gxem.event_class_code = g_batch_close
3652: in (SELECT
3653: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
3654: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
3655: FROM
3656: xla_post_acctg_events_v xpae,
3657: gmf_xla_event_model gxem
3658: WHERE
3659: gxem.process_category = G_order_management
3660: and xpae.event_class_code = gxem.event_class_code
3702: in (SELECT
3703: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
3704: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
3705: FROM
3706: xla_post_acctg_events_v xpae,
3707: gmf_xla_event_model gxem
3708: WHERE
3709: gxem.process_category = G_order_management
3710: and xpae.event_class_code = gxem.event_class_code
3751: WHERE transaction_id
3752: in (SELECT
3753: xpae.SOURCE_ID_INT_1
3754: FROM
3755: xla_post_acctg_events_v xpae,
3756: gmf_xla_event_model gxem
3757: WHERE
3758: gxem.process_category = G_order_management
3759: and xpae.event_class_code = gxem.event_class_code
3800: , request_id = g_request_id
3801: WHERE
3802: exists (SELECT 'x'
3803: FROM
3804: xla_post_acctg_events_v xpae,
3805: gmf_xla_event_model gxem,
3806: gmf_xla_extract_headers eh
3807: WHERE
3808: eh.transaction_id = xpae.SOURCE_ID_INT_1
3943: in (SELECT
3944: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
3945: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
3946: FROM
3947: xla_post_acctg_events_v xpae,
3948: gmf_xla_event_model gxem
3949: WHERE
3950: gxem.process_category = G_revaluation_transactions
3951: and xpae.event_class_code = gxem.event_class_code
3993: in (SELECT
3994: xpae.SOURCE_ID_INT_1, xpae.SOURCE_ID_INT_2,
3995: xpae.SOURCE_ID_INT_3, xpae.SOURCE_ID_CHAR_1
3996: FROM
3997: xla_post_acctg_events_v xpae,
3998: gmf_xla_event_model gxem
3999: WHERE
4000: gxem.process_category = G_revaluation_transactions
4001: and xpae.event_class_code = gxem.event_class_code
4036: WHERE transaction_id
4037: in (SELECT
4038: xpae.SOURCE_ID_INT_1
4039: FROM
4040: xla_post_acctg_events_v xpae,
4041: gmf_xla_event_model gxem
4042: WHERE
4043: gxem.process_category = G_revaluation_transactions
4044: and xpae.event_class_code = gxem.event_class_code
4061: SELECT cost_type
4062: INTO l_cost_method_type
4063: FROM cm_mthd_mst
4064: WHERE cost_type_id = (SELECT xpae.SOURCE_ID_INT_3
4065: FROM xla_post_acctg_events_v xpae
4066: WHERE rownum = 1)
4067: ;
4068:
4069: --
4100: WHERE adjustment_id
4101: in (SELECT
4102: xpae.SOURCE_ID_INT_1
4103: FROM
4104: xla_post_acctg_events_v xpae,
4105: gmf_xla_event_model gxem
4106: WHERE
4107: gxem.process_category = G_revaluation_transactions
4108: and gxem.transaction_type = 'LOT_COST_ADJUSTMENTS' /* Bug#5597804 ANTHIYAG 06-Nov-2006 */
4151: WHERE period_balance_id
4152: in (SELECT
4153: xpae.SOURCE_ID_INT_1
4154: FROM
4155: xla_post_acctg_events_v xpae,
4156: gmf_xla_event_model gxem
4157: WHERE
4158: gxem.process_category = G_revaluation_transactions
4159: and gxem.transaction_type = 'COST_REVALUATIONS' /*changed LOT_COST_ADJUSTMENTS to COST_REVALUATIONS jboppana*/
4198: WHERE cost_adjust_id
4199: in (SELECT
4200: xpae.SOURCE_ID_INT_1
4201: FROM
4202: xla_post_acctg_events_v xpae,
4203: gmf_xla_event_model gxem
4204: WHERE
4205: gxem.process_category = G_revaluation_transactions
4206: and gxem.transaction_type = 'ACTUAL_COST_ADJUSTMENTS'
4249: WHERE allocdtl_id
4250: in (SELECT
4251: xpae.SOURCE_ID_INT_1
4252: FROM
4253: xla_post_acctg_events_v xpae,
4254: gmf_xla_event_model gxem
4255: WHERE
4256: gxem.process_category = G_revaluation_transactions
4257: and gxem.transaction_type = 'GL_COST_ALLOCATIONS'