DBA Data[Home] [Help]

APPS.GMF_XLA_PKG dependencies on GMF_XLA_EVENT_MODEL

Line 548: FROM gmf_xla_event_model em

544:
545: update gmf_xla_extract_headers_gt ehgt
546: set (entity_code, event_class_code, event_type_code) =
547: (SELECT entity_code, event_class_code, event_type_code
548: FROM gmf_xla_event_model em
549: WHERE
550: ( em.transaction_source_type_id = ehgt.transaction_source_type_id
551: AND em.transaction_action_id = ehgt.transaction_action_id
552: AND nvl(em.organization, 'x') = nvl(ehgt.organization, 'x')

Line 2073: FROM gmf_xla_event_model em

2069: -- We need to loop for each process category as this is not a mandatory
2070: -- parameter to Create Accounting program.
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: )

Line 2224: gmf_xla_event_model gxem

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
2228: )

Line 2274: gmf_xla_event_model gxem

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
2278: )

Line 2321: gmf_xla_event_model gxem

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
2325: AND xpae.event_class_code NOT IN ('FOB_RCPT_SENDER_RCPT', 'FOB_SHIP_RECIPIENT_SHIP')

Line 2379: gmf_xla_event_model gxem

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
2383: AND xpae.event_class_code in ('SUBINV_XFER')

Line 2431: gmf_xla_event_model gxem

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
2435: AND xpae.event_class_code in ('FOB_RCPT_SENDER_RCPT', 'FOB_SHIP_RECIPIENT_SHIP')

Line 2563: gmf_xla_event_model gxem

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
2567: )

Line 2613: gmf_xla_event_model gxem

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
2617: )

Line 2661: gmf_xla_event_model gxem

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
2665: )

Line 2707: gmf_xla_event_model gxem

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',
2711: 'RECEIVING_RET_TO_VENDOR','DELIVER_EXP_RET_TO_RECEIVING',

Line 2757: gmf_xla_event_model gxem

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
2761: );

Line 2882: gmf_xla_event_model gxem

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
2886: )

Line 2932: gmf_xla_event_model gxem

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
2936: )

Line 2980: gmf_xla_event_model gxem

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
2984: and xpae.event_class_code = gxem.event_class_code

Line 3029: gmf_xla_event_model gxem

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
3033: )

Line 3082: gmf_xla_event_model gxem

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
3086: and xpae.event_class_code = gxem.event_class_code

Line 3128: gmf_xla_event_model gxem

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
3132: and xpae.event_class_code = gxem.event_class_code

Line 3255: gmf_xla_event_model gxem

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
3259: )

Line 3305: gmf_xla_event_model gxem

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
3309: )

Line 3353: gmf_xla_event_model gxem

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
3357: )

Line 3402: gmf_xla_event_model gxem,

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
3406: AND eh.ledger_id = xpae.SOURCE_ID_INT_2

Line 3545: gmf_xla_event_model gxem

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
3549: )

Line 3595: gmf_xla_event_model gxem

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
3599: )

Line 3638: gmf_xla_event_model gxem

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
3642: )

Line 3702: gmf_xla_event_model gxem

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 */
3706: and xpae.event_class_code = gxem.event_class_code

Line 3753: gmf_xla_event_model gxem

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*/
3757: and xpae.event_class_code = gxem.event_class_code

Line 3800: gmf_xla_event_model gxem

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'
3804: and xpae.event_class_code = gxem.event_class_code

Line 3851: gmf_xla_event_model gxem

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'
3855: and xpae.event_class_code = gxem.event_class_code