Purchasing Tables

EDW_PO_VENDOR_HIERARCHIES	PO_HEADERS_INTERFACE	PO_RESCHEDULE_INTERFACE
FND_FUNCTION_PARAMETER_MAP	PO_HISTORY_POS_ALL	PO_RETRIEVED_TIMECARDS
FND_NOTIFICATIONS	PO_HISTORY_RECEIPTS	PO_RFQ_VENDORS
POA_BIS_SAVINGS	PO_HISTORY_REQUISITIONS_ALL	PO_RULE_EXPENSE_ACCOUNTS
POA_BIS_SAVINGS_EFC	PO_HISTORY_VENDORS	PO_SUPPLIER_ITEM_CAPACITY
POA_BIS_SAVINGS_RPT	PO_INTERFACE_ERRORS	PO_SUPPLIER_ITEM_TOLERANCE
POA_BIS_SAVINGS_RPT_EFC	PO_JOB_ASSOCIATIONS_B	PO_SYSTEM_PARAMETERS_ALL
POA_BIS_SUPPLIER_PERFORMANCE	PO_JOB_ASSOCIATIONS_TL	PO_UNIQUE_IDENTIFIER_CONT_ALL
POA_BIS_SUPPLIER_PERFORMAN_EFC	PO_LINES_ALL	PO_UN_NUMBERS_B
POA_CM_DISTRIBUTIONS	PO_LINES_ALL_EBS	PO_UN_NUMBERS_TL
POA_CM_EVALUATION	PO_LINES_ARCHIVE_ALL	PO_USAGES
POA_CM_EVAL_SCORES	PO_LINES_INTERFACE	PO_USAGE_ATTRIBUTES
PO_ACCEPTANCES	PO_LINE_LOCATIONS_ALL	PO_VALIDATION_RESULTS_GT
PO_ACCRUAL_ACCOUNTS_TEMP_ALL	PO_LINE_LOCATIONS_ALL_EBS	PO_VENDORS
PO_ACCRUAL_RECONCILE_TEMP_ALL	PO_LINE_LOCATIONS_ARCHIVE_ALL	PO_VENDORS_EBS
PO_ACCRUAL_WRITE_OFFS_ALL	PO_LINE_LOCATIONS_GT	PO_VENDOR_CONTACTS
PO_ACCRUAL_WRITE_OFFS_ALL_EFC	PO_LINE_TYPES_B	PO_VENDOR_LIST_ENTRIES
PO_ACTION_HISTORY	PO_LINE_TYPES_TL	PO_VENDOR_LIST_HEADERS
PO_AGENTS	PO_LOCATION_ASSOCIATIONS	PO_VENDOR_SITES_ALL
PO_APPROVAL_LIST_HEADERS	PO_LOCATION_ASSOCIATIONS_ALL	PO_VENDOR_SITES_ALL_EBS
PO_APPROVAL_LIST_LINES	PO_MASSCANCEL_INCLUDES_ALL	PO_WF_CANDIDATE_REQ_LINES_TEMP
PO_APPROVED_SUPPLIER_LIST	PO_MASSCANCEL_INTERIM	PO_WF_DEBUG
PO_ASL_ATTRIBUTES	PO_MC_DISTRIBUTIONS	PO_WF_USER_TMP
PO_ASL_DOCUMENTS	PO_MC_HEADERS	RCV_ACCOUNTING_EVENTS
PO_ASL_STATUSES	PO_NOTES	RCV_ACCOUNTING_EVENT_TYPES
PO_ASL_STATUS_RULES	PO_NOTE_ATTRIBUTES	RCV_FTE_TRANSACTION_LINES
PO_ATT_TMP_RECORDS	PO_NOTE_REFERENCES	RCV_GAPLESS_INVOICE_NUMBERS
PO_AUTOSOURCE_DOCUMENTS_ALL	PO_NOTIFICATIONS_ALL	RCV_HEADERS_INTERFACE
PO_AUTOSOURCE_RULES	PO_NOTIFICATION_CONTROLS	RCV_LOTS_INTERFACE
PO_AUTOSOURCE_VENDORS	PO_ONLINE_REPORT_TEXT	RCV_LOTS_SUPPLY
PO_CHANGE_REQUESTS	PO_POSITION_CONTROLS_ALL	RCV_LOT_TRANSACTIONS
PO_COMMODITIES_B	PO_PRICE_DIFFERENTIALS	RCV_MC_REC_SUB_LEDGER
PO_COMMODITIES_TL	PO_PRICE_DIFFERENTIALS_ARCHIVE	RCV_MC_SHIPMENT_HEADERS
PO_COMMODITY_CATEGORIES	PO_PRICE_DIFF_INTERFACE	RCV_MC_SHIPMENT_LINES
PO_COMMODITY_GRANTS	PO_PURGE_PO_LIST	RCV_MC_SUB_LEDGER_DETAILS
PO_CONTROL_FUNCTIONS	PO_PURGE_RECEIPT_LIST	RCV_MC_TRANSACTIONS
PO_CONTROL_GROUPS_ALL	PO_PURGE_REQ_LIST	RCV_PARAMETERS
PO_CONTROL_RULES	PO_PURGE_VENDOR_LIST	RCV_RECEIVING_SUB_LEDGER
PO_CONTROL_RULES_EFC	PO_QUALITY_CODES	RCV_ROUTING_HEADERS
PO_DISTRIBUTIONS_ALL	PO_QUOTATION_APPROVALS_ALL	RCV_ROUTING_HEADERS_OLD
PO_DISTRIBUTIONS_ALL_EBS	PO_RELATED_TEMPLATES	RCV_ROUTING_STEPS
PO_DISTRIBUTIONS_ARCHIVE_ALL	PO_RELEASES_ALL	RCV_SERIALS_INTERFACE
PO_DISTRIBUTIONS_INTERFACE	PO_RELEASES_ALL_EBS	RCV_SERIALS_SUPPLY
PO_DOCUMENT_TOTALS_GT	PO_RELEASES_ARCHIVE_ALL	RCV_SERIAL_TRANSACTIONS
PO_DOCUMENT_TYPES_ALL_B	PO_REQEXPRESS_HEADERS_ALL	RCV_SHIPMENT_HEADERS
PO_DOCUMENT_TYPES_ALL_TL	PO_REQEXPRESS_LINES_ALL	RCV_SHIPMENT_LINES
PO_EMPLOYEE_HIERARCHIES_ALL	PO_REQUISITIONS_INTERFACE_ALL	RCV_SHIPMENT_LINES_EFC
PO_ENCUMBRANCE_GT	PO_REQUISITIONS_INT_ALL_EFC	RCV_SUB_LEDGER_DETAILS
PO_GA_ORG_ASSIGNMENTS	PO_REQUISITION_HEADERS_ALL	RCV_SUPPLY
PO_GA_ORG_ASSIGNMENTS_ARCHIVE	PO_REQUISITION_LINES_ALL	RCV_TRANSACTIONS
PO_HAZARD_CLASSES_B	PO_REQUISITION_LINES_ALL_EFC	RCV_TRANSACTIONS_INTERFACE
PO_HAZARD_CLASSES_TL	PO_REQUISITION_SUPPLIERS	RCV_UPGRADE_STEPS
PO_HEADERS_ALL	PO_REQ_DISTRIBUTIONS_ALL
PO_HEADERS_ALL_EBS	PO_REQ_DISTRIBUTIONS_ALL_EFC
PO_HEADERS_ARCHIVE_ALL	PO_REQ_DIST_INTERFACE_ALL

Is 3G Good for India?

Inventory Lookups

ATO_MATCH_RESERVE	MTL_ATP_CODE	MTL_KANBAN_ERROR_CODE
ATP_FLAG	MTL_ATP_INQUIRY_NAV	MTL_KANBAN_SOURCE_TYPE
ATP_SO_LOOKUP	MTL_ATP_INQUIRY_NAV2	MTL_KANBAN_SUPPLY_STATUS
CONSIGN_AGING_ADD_POPLIST	MTL_ATP_RULES_REGION	MTL_LINE_TYPE
CONSIGN_AGING_ADD_POPLIST_ISP	MTL_AUTHORIZED_VENDOR	MTL_LOCATION_CONTROL
CONTAINER_TYPE	MTL_AUTO_APPROVALS	MTL_LOCATION_PHYDATA
CZ_VALIDATE_ON_EXIT	MTL_AVAILABILITY	MTL_LOCATION_TYPE
DOC_TYPE	MTL_BALANCE_RPT_SEL	MTL_LOCATION_TYPES
DUEDATE_CRITERIA	MTL_CALCULATE_KANBAN_FLAG	MTL_LOCATOR_RESTRICTIONS
INTRASTAT_FORMAT_TYPE	MTL_CATEGORY	MTL_LOCATOR_RULE
INTRASTAT_REPORT_OPTION	MTL_CATEGORY_SCREENS	MTL_LOCATOR_TYPES
INVSRS_HAN_SEL	MTL_CAT_GROUP_SCREENS	MTL_LOGICAL_TRANSACTION_CODE
INV_BULK_PICK_CONTROL	MTL_CAT_SEARCH_SCREENS	MTL_LOT_CONTROL
INV_CATEGORY_SET_CONTROL_LEVEL	MTL_CAT_SET_DETAILS	MTL_LOT_GENERATION
INV_CAT_PEOPLE_PROF_OPT_TYPE	MTL_CAT_STATUS	MTL_LOT_ORIGINATION_TYPE
INV_CONFIG_MATCH_TYPE	MTL_CCEOI_ACTION_CODE	MTL_LOT_QUERY
INV_CONFIG_MATCH_TYPE	MTL_CCEOI_DELETE_PROC_RECS	MTL_LOT_RULE
INV_CONFIG_ORGS_TYPE	MTL_CCEOI_ERROR_REPORT_LEVEL	MTL_LOT_SAMPLING
INV_CONFIG_ORGS_TYPE	MTL_CCEOI_PROCESS_MODE	MTL_LOT_SELECT
INV_COPY_ORG_REPORT_ENTITIES	MTL_CCEOI_STATUS_FLAG	MTL_LOT_SELECTION
INV_CUMULATIVE_CRITERIA	MTL_CC_APPROVAL_ACTIONS	MTL_LOT_SIZE
INV_CUST_ITEM_ACTION_CODE	MTL_CC_APPROVAL_CONDITION	MTL_LOT_TRACE_SORT
INV_DEFAULTING_UOM_TYPE	MTL_CC_APPROVAL_MORE	MTL_LOT_UNIQUENESS
INV_DEFAULTING_UOM_TYPE	MTL_CC_APPROVAL_OPTIONS	MTL_LT_PLANNING
INV_GENEALOGY_EVENT_TYPE	MTL_CC_APPROVAL_TYPES	MTL_LT_QUERY_TYPE
INV_GENEALOGY_OBJECT_TYPE	MTL_CC_CONT_ADJ_OPTIONS	MTL_MAINTAIN_SERIAL_NAV
INV_GENEALOGY_ORIGIN	MTL_CC_CONT_DISCR_OPTIONS	MTL_MASS_DISPOSITION
INV_GENEALOGY_PREFIX_SUFFIX	MTL_CC_COUNT_TYPES	MTL_MATERIAL L_PLANNING
INV_GENEALOGY_TYPE	MTL_CC_DETAILS_NAV	MTL_MATERIAL_BURDEN
INV_ITEM_APPROVAL_STATUS	MTL_CC_ENTRY_MORE	MTL_MATERIAL_PLANNING
INV_ITEM_ATTRIBUTES	MTL_CC_ENTRY_STATUSES	MTL_MATERIAL_RECEIPT
INV_ITEM_DEFINITION_LEVEL	MTL_CC_INITIALIZATION_STATUS	MTL_MINMAX_HANDLE_REP_ITEM
INV_ITEM_DESC_GEN_METHOD	MTL_CC_MORE_NAV	MTL_MINMAX_LEVEL
INV_ITEM_NUM_GEN_METHOD	MTL_CC_ORIENTATION	MTL_MINMAX_ORDER
INV_LOC_QTY_RPT_MSGS	MTL_CC_PURGE_TYPE	MTL_MINMAX_RPT_SEL
INV_LOT_SERIAL_UPGRADE_OPTIONS	MTL_CC_SCHEDULE_STATUS	MTL_MINMAX_RPT_SORT_BY
INV_LOT_SER_GENERATE_OPTIONS	MTL_CC_SCHED_TIME	MTL_MSI_GP_FORECAST_TYPE
INV_MGD_HIER_PROPERTY_TYPE	MTL_CC_SERIAL_ADJ_OPTIONS	MTL_MSI_GP_RELEASE_AUTH
INV_MGD_HIER_PROPERTY_TYPE	MTL_CC_SERIAL_COUNT_OPTIONS	MTL_MSI_MRP_CONV_SUPP
INV_MISSING_QTY_ACTIONS	MTL_CC_SERIAL_DETAIL_OPTIONS	MTL_MSI_MRP_DIV_SUPP
INV_MMX_RPT_MSGS	MTL_CC_SERIAL_DISCREPY_OPTIONS	MTL_MSI_MRP_INT_ORG
INV_MORE_PTX_1	MTL_CC_SERIAL_UNIT_STATUSES	MTL_NEGATIVE_RECEIPT
INV_MORE_PTX_2	MTL_CC_SOURCE_TYPES	MTL_ONHAND_FLAG
INV_MORE_PTX_3	MTL_CC_SYSQTY	MTL_ONHAND_SOURCE
INV_MORE_TXN_DIST	MTL_CHARGE_TYPE	MTL_ONLINE_FLAG
INV_NEW_ITEM_REQUEST_REQD	MTL_COMMISSION	MTL_OPERATORS
INV_PARENT_CHILD_GENERATION	MTL_COMMODITY	MTL_PARAMETERS
INV_PICK_METHODOLOGIES	MTL_CONFIG_STATUS	MTL_PERIOD_TYPES
INV_PICK_SLIP_MO_TYPES	MTL_CONSIGN_DIAG_CONSM_ER_TYPE	MTL_PHYSICAL_PURGE_TYPE
INV_PICK_SLIP_PRINT_OPTIONS	MTL_CONSUMPTION_ADVICE_STATUS	MTL_PHYSICAL_RECV
INV_PRICING_UOM_TYPE	MTL_CONVERSION_TYPE	MTL_PHYSICAL_SORT
INV_PRICING_UOM_TYPE	MTL_COST_OPTION	MTL_PHYSICAL_SORT_RECV
INV_PROCESS_MODE	MTL_COST_TYPE	MTL_PHYSICAL_SORT_STK
INV_RCV_DELIVER_TYPE	MTL_COUNT_STATUS	MTL_PHYSICAL_SORT_WIP
INV_REASON_CONTEXT	MTL_COUNT_TYPES	MTL_PHYSICAL_STK
INV_REASON_TYPES	MTL_CROSS_RPT	MTL_PHYSICAL_TRANSIT
INV_REPAIR_PROGRAMS	MTL_CYCLE_ACTIVITY	MTL_PHYSICAL_TYPE
INV_REPORT_GENEALOGY_TYPE	MTL_CYCLE_COUNT	MTL_PHYSICAL_WIP
INV_RESERVATION_SOURCE_TYPES	MTL_CYCLE_SELECT	MTL_PHY_DFN_SCOPE
INV_REV_YES_NO	MTL_DATA_RPT	MTL_PICK_APPL_SOURCE
INV_RMA_INSPECTION	MTL_DATA_SORT	MTL_PICK_LOCATOR_RULE
INV_SEARCH_OPTIONS	MTL_DEFAULT_LOCATORS	MTL_PICK_LOT_RULE
INV_SRS_ABC_SORT_OPTION	MTL_DEFAULT_SUBINVENTORY	MTL_PICK_REVISION_RULE
INV_SRS_ACS_SORT	MTL_DEFINE_SUBINV_MORE	MTL_PICK_SLIP_REPORT_OPTIONS
INV_SRS_ASC_DESC	MTL_DEMAND_ACTION_CODE	MTL_PICK_SUBINVENTORY_RULE
INV_SRS_CAT_SORT	MTL_DEMAND_HIS	MTL_PLANNING_BOM
INV_SRS_CC_ENTRIES_SORT	MTL_DEMAND_INTERFACE_ERRORS	MTL_PLANNING_MAKE_BUY
INV_SRS_CLS_SORT	MTL_DEMAND_ROW_STATUS	MTL_PLANNING_SCREENS
INV_SRS_DST_SORT	MTL_DEMAND_TYPE	MTL_PO_SCREENS
INV_SRS_DST_TYPE	MTL_DEMPROC_STATUS	MTL_PO_TXN
INV_SRS_ELT_SORT	MTL_DETAIL_RESERVATION	MTL_PRODUCT_FAMILY
INV_SRS_HAN_SEL	MTL_DISPOSITION	MTL_PRODUCT_FAMILY_RANGE
INV_SRS_HAN_SORT	MTL_DISPOSITION_QUERY	MTL_PRODUCT_FAMILY_SELECT
INV_SRS_INVARCLI_PARAM_EXPORT	MTL_DISPOSITION_RPT	MTL_QUANTITY_TYPE
INV_SRS_INVIRCIT_SORT	MTL_DISPOSITION_SORT	MTL_RANGE_SUBINVENTORY
INV_SRS_INVIRCXR_SORT	MTL_DISPOSITION_TYPE	MTL_RC_LINE_FAILURE
INV_SRS_ITS_DESC	MTL_DISP_TYPE	MTL_RECEIVING
INV_SRS_ITS_SORT	MTL_DIST_SUMMARY	MTL_RECEIVING_TYPE
INV_SRS_LNT_SORT	MTL_DOCUMENT_APPROVAL_RELEASE	MTL_REFERENCE_TYPE
INV_SRS_MMX_REPORT_FORMAT	MTL_DOCUMENT_EDIT	MTL_RELATIONSHIP_TYPES
INV_SRS_PHYS_TAG_SORT	MTL_DOCUMENT_FREQUENCY	MTL_RELEASE
INV_SRS_PRECISION	MTL_DOCUMENT_LINE_TYPES	MTL_RELEASE_TIME_FENCE
INV_SRS_PSL_SORT	MTL_DOCUMENT_PRINT	MTL_REORDER_RPT
INV_SRS_PTS_OPTION	MTL_DOCUMENT_REV_STATUS	MTL_REORDER_SORT_BY
INV_SRS_REG_BREAK	MTL_DOCUMENT_SCREENS	MTL_REORDER_TYPE
INV_SRS_REG_SORT	MTL_DOCUMENT_SECURITY	MTL_REPETITIVE_CONTROL
INV_SRS_REG_UOM	MTL_DOCUMENT_SELECT	MTL_REPLENISHMENT_ERROR
INV_SRS_RIT_DESC_TYPE	MTL_DOCUMENT_SORT	MTL_REPLENISH_ACTIONS
INV_SRS_RSV_SORT	MTL_DOCUMENT_TYPES	MTL_REPL_MO_GROUPING
INV_SRS_SNO_UNIT_TYPE	MTL_DOCUMENT_ZONES	MTL_REQUISITION_APPROVAL
INV_SRS_SNT_SORT	MTL_DOC_BLOCKS	MTL_RESERVABLE_SUBINVENTORY
INV_SRS_STS_SEL	MTL_EAM_ACTIVITY_CAUSE	MTL_RESERVATION
INV_SRS_VLT_SORT	MTL_EAM_ACTIVITY_SOURCE	MTL_RESERVATIONS_DISPLAY
INV_SRS_XRF_TYPE	MTL_EAM_ACTIVITY_TYPE	MTL_RESERVATION_ACTION_CODE
INV_SUBCONT_COMPONENT	MTL_EAM_ASSET_CRITICALITY	MTL_RESERVATION_CONTROL
INV_TM_ERROR_CODE	MTL_EAM_ASSET_TYPE	MTL_RESERVATION_DISP
INV_TRACKING_UOM_TYPE	MTL_EAM_ITEM_TYPE	MTL_RESERVATION_ITEM
INV_TRACKING_UOM_TYPE	MTL_ECN_QUANTITY_CONTROL	MTL_RESERVATION_RULE
INV_TRANSACTION_FLOW_QUALIFIER	MTL_EFFECTIVITY_CONTROL	MTL_RESERVATION_SORT
INV_TRANSACTION_FLOW_TYPE	MTL_ELEMENT_TYPE	MTL_RES_REPLEN
INV_TXN_DTL_MORE	MTL_ELVAL_SORT_CODE	MTL_RES_RPT
INV_TXN_FLOW_PRICING_OPTIONS	MTL_ENG_QUANTITY	MTL_RETURNABILITY
INV_UPDATE_TYPE	MTL_FAMILY_ENTRY	MTL_RETURN_INSPECTION
INV_YES_NO	MTL_FOB_POINT	MTL_RETURN_TYPE
INV_YES_NO_ERROR	MTL_FOCUS_CALENDAR	MTL_REVISION_RULE
INV_YES_NO_ERROR_NA	MTL_FORECAST	MTL_RFQ_CONTROL
ITEM_ATTRIBUTE_VALIDATION	MTL_FORECAST_RULE_REGION	MTL_ROLL_TYPE
ITEM_CHOICES	MTL_FREQUENCY_CODE	MTL_ROLL_UPDATE
ITEM_CHOICES_GUI	MTL_FUNCTIONAL_AREAS	MTL_ROUNDING
ITEM_CONTROL_LEVEL	MTL_GENERIC_DISP_LIST	MTL_SAFETY_STOCK
ITEM_CONTROL_LEVEL_GUI	MTL_GL_BATCH_STATUS	MTL_SAFETY_STOCK_TYPE
ITEM_ORG_FUNCTIONS	MTL_GL_UPDATE_CODE	MTL_SCHEDULE_CHANGE_TYPE
ITEM_STATUS_CONTROL	MTL_INIT_OPERATION	MTL_SEARCH_ZOOM_LIST
ITEM_STATUS_CONTROL_USAGE	MTL_INSPECTION_STATUS	MTL_SECONDARY
ITEM_TYPE	MTL_INTER_INV_TRANSFER	MTL_SECONDARY_INV_REQUEST
MCG_ASSEMBLY	MTL_INTRANSIT_REP_SORT	MTL_SECONDARY_NETTING
MCG_AUTOLOAD_OPTION	MTL_INTRANSIT_VIEW_RPT	MTL_SECONDARY_TYPES
MCG_BILL_OF_MATERIAL_DISPLAY2	MTL_INTRA_INV_TRANSFER	MTL_SERIAL_GENERATION
MCG_BOM_SCREENS	MTL_INVENTORIES	MTL_SERIAL_NUMBER
MCG_CAL_CAL	MTL_INVENTORY	MTL_SERIAL_NUMBER_ENTRY
MCG_OPERATION	MTL_INVENTORY_ABC	MTL_SERIAL_NUMBER_RPT
MCG_OPERATION_SCHEDULE	MTL_INVENTORY_STK	MTL_SERIAL_NUMBER_RULE
MIN_MAX_REPORT_LOT_CONTROL	MTL_INVENTORY_TYPES	MTL_SERIAL_NUMBER_TYPE
MOVE_ORDER_TYPE	MTL_INVXCT_SORT	MTL_SERVICE_OPTION
MTL_ABC_ASSIGN_SELECT	MTL_INV_RES	MTL_SETUP_RPT
MTL_ABC_CLASS	MTL_INV_SCREENS	MTL_SHELF_LIFE
MTL_ABC_COMPILE	MTL_INV_TRANSACTION_STATUS	MTL_SHORTAGE_OBJECT_TYPE
MTL_ABC_COMPILE_REPORT	MTL_ISSUE_RECEIPT_REQUEST	MTL_SHORTAGE_PROCESS_CODE
MTL_ABC_COMPILE_SORT	MTL_ITEMSUB_MORE	MTL_SHORT_SUM_PRINT_GROUP
MTL_ABC_COMPILE_STATUS	MTL_ITEM_COST	MTL_SN_SHIPPED
MTL_ABC_COMPILE_TYPE	MTL_ITEM_LOCATION	MTL_SN_SUMMARY
MTL_ABC_DATA_SETS	MTL_ITEM_LOCATOR_CONTROL	MTL_SORT_BY2
MTL_ABC_DISPOSITION_TYPE	MTL_ITEM_ORIGINATION	MTL_SORT_BY4
MTL_ABC_INVENTORY	MTL_ITEM_ORIGINATION1	MTL_SOURCE_TYPES
MTL_ABC_ITEM_SCOPE	MTL_ITEM_ORIGINATION2	MTL_STATUS_ACTIVITY
MTL_ABC_PURGE_TYPE	MTL_ITEM_PLANNING_QUERY	MTL_STATUS_ALL
MTL_ABC_RANGE	MTL_ITEM_QUANTITY_SORT	MTL_STATUS_ATTRIBUTES
MTL_ABC_REPSORT	MTL_ITEM_RANGE	MTL_STATUS_INVENTORY
MTL_ABC_SORT	MTL_ITEM_RPT	MTL_STATUS_UPDATE_METHOD
MTL_ABC_TRANSACT	MTL_ITEM_SCREEN	MTL_SUBINVENTORY_RESTRICTIONS
MTL_ACCOUNT_CONTROL	MTL_ITEM_STATUS_QUERY	MTL_SUBINVENTORY_RULE
MTL_ACCT_PERIOD_STATUS	MTL_ITEM_STATUS_QUERY1	MTL_SUBINVENTORY_TYPE
MTL_AGGREGATE_GROUP	MTL_ITEM_TYPE	MTL_SUBINV_OPT
MTL_AGGREGATE_QTY	MTL_ITEM_VALIDITY	MTL_SUB_TYPE
MTL_AGGREGATE_SELECT	MTL_JIT_CONTROL	MTL_SUB_TYPES
MTL_ALL_ORG	MTL_KANBAN_AGGREGATION_TYPE	MTL_SUPPLY_DEMAND_SOURCE_TYPE
MTL_APPROVALS	MTL_KANBAN_CARD_PRINT_SORT	MTL_SUPPLY_WIP_CONTROL
MTL_APPROVAL_REQ	MTL_KANBAN_CARD_STATUS	MTL_TAG_GENERATION
MTL_AR_INVOICE_LOAD	MTL_KANBAN_CARD_TYPE	MTL_TEMP_ITEM
MTL_ASSIGNMENT_LEVEL	MTL_KANBAN_DOCUMENT_TYPE	MTL_TEMP_ITEM1
MTL_TIME_FENCE	MVT_STATUSES	PCH_REC_SEL_RPT
MTL_TP_TYPES	MVT_STAT_TYPES	PCH_REC_SORT
MTL_TRANSACTION_ACTION	MVT_SUPPLY_REFERENCE	PCH_RESERVATION_RPT
MTL_TRANSACTION_DATE	MVT_TRANSACTION_NATURE	PCH_SETUP_RPT
MTL_TRANSACTION_DIRECTION	MVT_TRANSPORT_MODE	PCH_TRANSACTION_TYPE
MTL_TRANSACTION_MODE	MVT_USAGE_TYPES	PICK_SLIP_ORDER_TYPE
MTL_TRANSFER_ORDER_STATUS	OPERATIONS_VIEW	PJM_MISC_TXN_EXP_TYPE
MTL_TRANSFER_RECEIVING	ORG_ALTERNATE_TAX	PROCESS_STATUS
MTL_TRANSIT_RANGE	ORG_CALENDAR	PROCESS_TYPE
MTL_TRANSPORTATION_ZONES	ORG_CHART	SERIAL_NUM_STATUS
MTL_TRANS_PROC	ORG_COM	SHIP_METHOD
MTL_TRAVELER_PRINT	ORG_CONTAINER	SYS_COST_WO_COST
MTL_TXN_ISSUE_RECEIPT	ORG_DEPARTMENT	SYS_COST_WO_PENDING
MTL_TXN_REQUEST_SOURCE	ORG_DEPT_INIT	SYS_COST_WPENDING
MTL_TXN_REQUEST_STATUS	ORG_DEPT_RANGE	SYS_ERROR_SEL
MTL_TXN_USAGE	ORG_DEPT_SCREENS	SYS_INVENTORY_SCOPE
MTL_UOM_CONVERSIONS	ORG_DEPT_SCREENS1	SYS_RANGE
MTL_USAGE_COMPILE_BY	ORG_DEPT_SEL	SYS_RANGE_CAT
MTL_VAL_COST_CODE	ORG_DPT_LOT_SPLITTING	SYS_RANGE_LIST
MTL_VAL_RANGE	ORG_EMP_MARITAL	SYS_RANGE_WITH_CAT
MTL_VAL_SORT_CODE	ORG_FREIGHT	SYS_SCREEN1
MTL_VIEW_ATP_MORE	ORG_INTER_ORG_SUPPLY	SYS_SERIAL_NUM
MTL_VOID	ORG_INTRANSIT	SYS_YES_NO
MTL_WARRANTY_CONTROL	ORG_LICENSE	TRANSACTION_STATUS_SELECTION
MTL_WIP_ALL	ORG_OVERHEAD_COST	TXN_APPROVAL_TIMEOUT_ACTION
MTL_WIP_CONTROL	ORG_OVERHEAD_DEPT	TXN_LOT_INQ_DTL_SELECTION
MTL_WIP_CONTROL1	ORG_OVERHEAD_ORIGINATION	VIEW_CONSIGN_MATERIAL_AGING
MTL_WIP_MASS	ORG_OVERHEAD_RESOURCE	WMS_PICK_METHODOLOGIES
MTL_WIP_RPT_CNTRL	ORG_RANGE	WMS_REASON_TYPES
MTL_WIP_TAG	ORG_REPLENISHMENT	WORK_LINE_TYPE
MTL_WIP_TO	ORG_RESOURCE	WORK_ORDER_TYPE
MTL_WIP_TYPE	ORG_RESOURCE_CAPACITY	YES_NO_SYS
MTL_WIP_XFER	ORG_RESOURCE_COST	MVT_OUTSIDE_CODE
MVT_AFFILIATIONS	ORG_RESOURCE_USE	MVT_PARTNER_VAT
MVT_AMOUNT_DISPLAY	ORG_SECURITY_PROFILE	MVT_PORT
MVT_AREA	ORG_SELECTION	MVT_RESET_OPTION
MVT_ATTRIBUTE_NAME	ORG_SETUP_RPT	MVT_SOURCE_DOCUMENT_TYPES
MVT_ATTRIBUTE_PROPERTY	ORG_SHIP_METHOD	MVT_STATISTICAL_TYPE
MVT_CONTAINER	ORG_SHIP_ZONES	MVT_FLOW_INDICATOR
MVT_CURR_CONV_OPTION	ORG_UOM	MVT_MINERAL_REFERENCE
MVT_DELIVERY_TERMS	ORG_WORK	PARTIAL_YES_NO
MVT_MOVEMENT_TYPE	PARTIAL_YES_NO	PCH_DISPOSITION_TYPE

Inventory Concurrent Executable & Short Name

AZAPITESTER	INVCTXNM	INVSHPRC
BOMRDDEL	INVDRRSV	INVSRAAL
BOMRDDELG	INVGCORP	INVSRFRT
INCAAA	INVGIAUP	INVSRIOS
INCAAC	INVGIDEP	INVSRISA
INCAAP	INVGIPPA	INVSRLOC
INCACG	INVGIPPG	INVSROPT
INCACI	INVGIPPR	INVSRPLN
INCACP	INVGRACHG	INVSRSHM
INCACS	INVGTPG	INVSRSPT
INCAPA	INVINPSR	INVSRSUB
INCAPF	INVIOICRE	INVSRUOM
INCAPP	INVIOIUPD	INVSTMVT
INCAPT	INVIRCAT	INVTMLPR
INCDCM	INVIRCIT	INVTOPKL
INCDSS	INVIRCOC	INVTPGWB
INCFDH	INVIRCXR	INVTRACS
INCFIF	INVIRDIS	INVTRCLS
INCIAP	INVIRDST	INVTRDST
INCIAR	INVIRILC	INVTRELT
INCIDV	INVIRISQ	INVTRHAN
INCIPS	INVIRITD	INVTRLNT
INCOIN	INVIRITS	INVTRREG
INCRPG	INVIRMMX	INVTRSHS
INCRPR	INVIRMOQ	INVTRSNT
INCRVL	INVIRRCR	INVTRSTS
INCTCC	INVIRRIT	INVTRVLT
INCTCM	INVIRROP	INVTURNITMS
INCTCW	INVIRSIQ	INVTURNS
INCTPG	INVIRSLO	INV_CONSOLIDATE_ONHAND
INCTPK	INVIRSNO	INV_CREATE_DEF_TXNS
INCTSN_SRS	INVIRTMP	INV_ITEM_CAT_ASSIGN_OI
INVAOPR	INVIRXRF	INV_ITEM_CAT_GRP_ELE_OI
INVARAAS	INVISCOR	INV_RSV_UPGRADE
INVARADV	INVISCORP	INXATP
INVARCLI	INVISMMX	INXDSD
INVARCPA	INVITEMORG_ASSIGN	INXGRP
INVARCTA	INVKBCGN	INXTCW
INVARHMA	INVKBCPR	INXTPU
INVARORE	INVLOC	IOICREATE5
INVARPAR	INVLOTAG	IOIUPDATE5
INVARPIA	INVLOTINV	MRPATPRS
INVARPMT	INVLOTMAS	MTL_CCEOI_EXPORT
INVARPSL	INVLSDAT	MTL_CCEOI_IMPORT
INVARPTG	INVLSUPG	MTL_CCEOI_PURGE
INVARPTP	INVLTGEN	MTL_CCEOI_WORKER
INVARPTS	INVM2MQT	SERIAL_NUMBER_GENERATION
INVARRTA	INVMATSTA	INVPRFRL
INVARUIR	INVMBTRX	INVRCWSR
INVCCIDP	INVMOPG	INVRSVIN
INVCCIER	INVMRMQT	INVCORPP
INVCCTCA	INVMSCHR	INVCPCLOS
INVCGUGB	INVMSWHU	INVCPOPEN
INVCHGPU	INVMVTEX	INVCPRG
INVCIINT	INVONHSP	INVCTXCW
INVCIINTX	INVORGES	INVPRFDH
INVCMVT	INVPOPSR	INVCMVTST

Basic SQL Query..

ISSUE	QUERY
Query PO Interface Table with ERROR and ITEM ID	Select perr.ERROR_MESSAGE, prh.item_id, msi.segment1, perr.* ,prh.* from PO_REQUISITIONS_INTERFACE_ALL prh , mtl_system_items_b msi , po_interface_errors perr where prh.ITEM_ID = msi.INVENTORY_ITEM_ID and perr.request_ID = prh.REQUEST_ID and msi.SEGMENT1 like ‘NE%’;
Query Table Name	select * from all_objects where object_name like ‘PO%ERROR%’
Compound IF Condition	DECLARE v_name VARCHAR2(50); v_sal NUMBER; BEGIN v_name := ‘Kumar’; v_sal := 25000; IF v_name = ‘Kumar’ AND v_sal >= 25000 THEN DBMS_OUTPUT.PUT_LINE(‘Salary of ‘||v_name||’ is ‘||v_sal); END IF; END;
For Loop	FOR LOOP DECLARE   a NUMBER; BEGIN     FOR i IN 1..30 LOOP       DBMS_OUTPUT.PUT_LINE(‘NUMERALS : ‘||TO_CHAR(I));     END LOOP; END;
IF THEN ElSE Condition	DECLARE v_hire_date DATE := ’12-Dec-1990′; v_five_years BOOLEAN; BEGIN IF MONTHS_BETWEEN(SYSDATE,v_hire_date)/12 > 5 THEN DBMS_OUTPUT.PUT_LINE(‘Hire Date ‘||v_hire_date||’ is Greater than 5 Years’); ELSE DBMS_OUTPUT.PUT_LINE(‘Hire Date ‘||v_hire_date||’ Less than 5 Years’); END IF; END;
IF THEN ElSE Condition	DECLARE v_start NUMBER; BEGIN v_start := 85; IF v_start > 100 THEN v_start := 0.2 * v_start; DBMS_OUTPUT.PUT_LINE(‘Result = ‘||v_start); ELSIF v_start >= 50 THEN v_start := 0.5 * v_start; DBMS_OUTPUT.PUT_LINE(‘Result = ‘||v_start); ELSE v_start := 0.1 * v_start; DBMS_OUTPUT.PUT_LINE(‘Result = ‘||v_start); END IF; END;
PL SQL	DECLARE A NUMBER; B NUMBER; RES NUMBER; BEGIN A := 50; B := 75; RES := A + B; DBMS_OUTPUT.PUT_LINE(‘A + B = ‘||RES); END;
SIMPLE IF	DECLARE v_name VARCHAR2(50); BEGIN v_name := ‘Chain-Sys’; IF v_name = ‘Chain-Sys’ THEN DBMS_OUTPUT.PUT_LINE(‘Name is ‘||v_name); END IF; END;
SIMPLE LOOP	declare   a number:= 1; Begin   loop   a := a + 1;   dbms_output.put_line(a);   EXIT when a= 10;  End loop; End;
Select Statement	SELECT empno, ename, job, hiredate, sal FROM emp;
Select Statement	SELECT e.empno, e.ename, e.job, e.hiredate, e.sal, d.dname FROM emp e, dept d where e.deptno = d.deptno;
Select Statement	SELECT ename, sal, sal + 300 NEW_SAL FROM emp;
Select Statement	SELECT ename, sal, 12*sal+100 NEW_SAL FROM emp;
Select Statement	SELECT DISTINCT deptno from emp;
Select Statement	SELECT empno, ename, job, hiredate, sal FROM emp WHERE deptno = 10;
Select Statement	SELECT empno, ename, job, hiredate, sal FROM emp WHERE sal BETWEEN 2000 and 3000;
Select Statement	SELECT count(*) FROM emp;
Select Statement	SELECT empno, ename FROM emp WHERE empno IN (7369,7499,7654);
Select Statement	SELECT empno, ename FROM emp WHERE ename LIKE  ‘_M%’
Select Statement	SELECT empno, ename FROM emp WHERE sal > 800 AND job = ‘CLERK’
Select Statement	SELECT deptno, empno, ename, sal FROM emp WHERE sal > 700 ORDER BY deptno, sal
Select Statement	SELECT ROUND(45.923,2), ROUND(45.923,0),ROUND(45.923,-1) FROM DUAL;
Select Statement	SELECT deptno, empno, ename, sal , (SYSDATE-hiredate)/7 AS WEEKS FROM emp;
Select Statement	SELECT MONTHS_BETWEEN (’01-SEP-95′,’11-JAN-94′) FROM DUAL;
Select Statement	SELECT ADD_MONTHS (’11-JAN-94′,6) FROM DUAL;
Select Statement	SELECT NEXT_DAY (’01-SEP-95′,’FRIDAY’) FROM DUAL;
Select Statement	SELECT LAST_DAY(’01-FEB-95′) FROM DUAL;
Select Statement	SELECT ENAME, HIREDATE, TO_CHAR(hiredate, ‘fmDD Month YYYY’) AS HIREDATE FROM EMP;
Select Statement	SELECT ENAME, TO_CHAR(sal, ‘$99,999.00′) SALARY FROM emp;