Entries by Oracle ERP Apps Guide

, , ,

How to Get GL Code Combination Description

Script 1:(Works in Both 11i & R12) SELECT gcc.segment1 ||’.’ ||gcc.segment2 ||’.’ ||gcc.segment3 ACCOUNT, A1.DESCRIPTION ||’-‘ ||A2.DESCRIPTION ||’-‘ || A3.DESCRIPTION DECS FROM fnd_flex_values_vl A1, fnd_flex_values_vl A2, fnd_flex_values_vl A3, gl_code_combinations gcc WHERE a1.flex_value       =gcc.segment1 AND a1.FLEX_VALUE_SET_ID IN (SELECT FLEX_VALUE_SET_ID FROM fnd_id_flex_segments WHERE application_id       = 101 AND id_flex_code       […]

, , , , ,

Important OPM Process Execution & Inventory Tables in R12

OPM PROCESS EXECUTION TABLES R12 GME_BATCH_HEADER GME_BATCH_HEADER_MIG GME_BATCH_HISTORY GME_BATCH_MAPPING_MIG GME_BATCH_SALES_ORDERS GME_BATCH_STEPS GME_BATCH_STEPS_MIG GME_BATCH_STEP_ACTIVITIES GME_BATCH_STEP_ACTIV_MIG GME_BATCH_STEP_CHARGES GME_BATCH_STEP_CHARGES_MIG GME_BATCH_STEP_DEPENDENCIES GME_BATCH_STEP_DEP_MIG GME_BATCH_STEP_ITEMS GME_BATCH_STEP_ITEMS_MIG GME_BATCH_STEP_RESOURCES GME_BATCH_STEP_RESOURCES_MIG GME_BATCH_STEP_RSRC_SUMMARY GME_BATCH_STEP_TRANSFERS GME_BATCH_STEP_TRANSFERS_MIG GME_BATCH_TXNS_MIG GME_ERES_GTMP GME_EXCEPTIONS_GTMP GME_GANTT_DOCUMENT_FILTER GME_INVENTORY_TXNS_GTMP GME_LAB_BATCH_LOTS GME_MATERIAL_DETAILS GME_MATERIAL_DETAILS_MIG GME_MATERIAL_DISPENSING_GTMP GME_MIGRATION_CONTROL GME_PARAMETERS GME_PENDING_PRODUCT_LOTS GME_PROCESS_PARAMETERS GME_PROCESS_PARAMETERS_MIG GME_RESOURCE_TXNS GME_RESOURCE_TXNS_GTMP GME_RESOURCE_TXNS_MIG GME_RESOURCE_TXNS_SUMMARY GME_SCALE_DETAIL GME_TEMP_EXCEPTIONS GME_TEXT_HEADER GME_TEXT__TL GME_TRANSACTION_PAIRS GME_UNALLOCATED_ITEMS_GTMP OPM INVENTORY TABLE R12 BISOPM_ONHANDSALE_SUM BIS_OPM_PROD_SUM […]