[Home] [Help]
558:
559: update gmf_xla_extract_headers_gt ehgt
560: set (entity_code, event_class_code, event_type_code) =
561: (SELECT entity_code, event_class_code, event_type_code
562: FROM gmf_xla_event_model em
563: WHERE
564: ( em.transaction_source_type_id = ehgt.transaction_source_type_id
565: AND em.transaction_action_id = ehgt.transaction_action_id
566: AND nvl(em.organization, 'x') = nvl(ehgt.organization, 'x')
2295: -- We need to loop for each process category as this is not a mandatory
2296: -- parameter to Create Accounting program.
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: )
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
2456: )
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
2506: )
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
2556: AND xpae.event_class_code NOT IN ('FOB_RCPT_SENDER_RCPT', 'FOB_SHIP_RECIPIENT_SHIP') ); */
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
2577: AND xpae.event_class_code in ('SUBINV_XFER')); */
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
2598: AND xpae.event_class_code in ('FOB_RCPT_SENDER_RCPT', 'FOB_SHIP_RECIPIENT_SHIP')); */
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')
2618: UNION ALL
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')
2631: )
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'))
2645: ;
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
2842: )
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
2892: )
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
2941: /*Bug 13033147 - Added following condition to exclude Receiving txns from this update*/
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',
2989: 'RECEIVING_RET_TO_VENDOR','DELIVER_EXP_RET_TO_RECEIVING',
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
3039: );
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
3085: );
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
3125: );
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
3164: );
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
3287: )
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
3337: )
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
3386: and xpae.event_class_code = gxem.event_class_code
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
3435: )
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
3488: and xpae.event_class_code = gxem.event_class_code
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
3534: and xpae.event_class_code = gxem.event_class_code
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
3661: )
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
3711: )
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
3760: )
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
3809: AND eh.ledger_id = xpae.SOURCE_ID_INT_2
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
3952: )
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
4002: )
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
4045: )
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 */
4109: and xpae.event_class_code = gxem.event_class_code
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*/
4160: and xpae.event_class_code = gxem.event_class_code
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'
4207: and xpae.event_class_code = gxem.event_class_code
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'
4258: and xpae.event_class_code = gxem.event_class_code