DBA Data[Home] [Help] [Dependency Information]


SYNONYM: APPS.MTL_LOT_NUMBERS

Object Details
Object Name: MTL_LOT_NUMBERS
Object Type: SYNONYM
Owner: APPS
Subobject Name:
Status: VALID
Synonym Details
Base Object: INV.MTL_LOT_NUMBERS

Dependencies

[top of page]

APPS.MTL_LOT_NUMBERS references the following:

SchemaINV
TableMTL_LOT_NUMBERS
APPS.MTL_LOT_NUMBERS is referenced by following:

SchemaAPPS
PL/SQL PackageAHL_COMPLETIONS_PVT - show dependent code
PL/SQL PackageAHL_OSP_ORDERS_PVT - show dependent code
Package BodyAHL_OSP_ORDERS_PVT - show dependent code
Package BodyAHL_OSP_RCV_PVT - show dependent code
PL/SQL PackageAHL_OSP_SHIPMENT_PUB - show dependent code
PL/SQL PackageAHL_PRD_DISPOSITION_PVT - show dependent code
Package BodyAHL_PRD_DISPOSITION_PVT - show dependent code
PL/SQL PackageAHL_PRD_DISP_MTL_TXN_PVT - show dependent code
Package BodyAHL_PRD_DISP_UTIL_PVT - show dependent code
PL/SQL PackageAHL_PRD_DISP_UTIL_PVT - show dependent code
PL/SQL PackageAHL_PRD_MTLTXN_PVT - show dependent code
Package BodyAHL_PRD_MTLTXN_PVT - show dependent code
Package BodyAHL_PRD_PARTS_CHANGE_PVT - show dependent code
PL/SQL PackageAHL_UC_INSTANCE_PVT - show dependent code
Package BodyAHL_UC_INSTANCE_PVT - show dependent code
ViewCLN_INV_LOT_NUM_V
Package BodyCLN_SYNC_INVENTORY_PKG - show dependent code
Package BodyCSD_LOGISTICS_UTIL - show dependent code
Package BodyCSD_UPDATE_PROGRAMS_PVT - show dependent code
Package BodyCSI_ITEM_INSTANCE_VLD_PVT - show dependent code
Package BodyCSI_T_VLDN_ROUTINES_PVT - show dependent code
ViewCSP_GET_LOT_NUMBERS_V
Package BodyCSP_MO_MTLTXNS_UTIL - show dependent code
Package BodyCSP_RECEIVE_PVT - show dependent code
Package BodyEAM_WORKORDERS_JSP - show dependent code
Package BodyEAM_WO_COMP_VALIDATE_PVT - show dependent code
ViewEDW_OPI_LOTD_LOT_LCV
Package BodyFLM_EXECUTION_UTIL - show dependent code
Package BodyGMA_MIGRATION_UTILS - show dependent code
PL/SQL PackageGMD_COA_DATA_OM_NEW - show dependent code
Package BodyGMD_COMMON_GRP - show dependent code
Package BodyGMD_ITEM_TECHNICAL_DATA_PUB - show dependent code
Package BodyGMD_LABUOM_CALCULATE_PKG - show dependent code
Package BodyGMD_QC_MIG12 - show dependent code
Package BodyGMD_QMSMC - show dependent code
Package BodyGMD_QM_UOM - show dependent code
Package BodyGMD_RESULT_TRANSFER_GRP - show dependent code
Package BodyGMD_SAMPLES_GRP - show dependent code
Package BodyGMD_SAMPLES_PUB - show dependent code
Package BodyGMD_SPEC_VRS_GRP - show dependent code
Package BodyGMD_SPREAD_FETCH_PKG - show dependent code
PL/SQL PackageGME_API_PUB - show dependent code
Package BodyGME_API_PUB - show dependent code
Package BodyGME_COMMON_PVT - show dependent code
ViewGME_INV_TXNS_ERES_V
ViewGME_INV_TXNS_TEMP_ERES_V
ViewGME_INV_TXN_LOTS_ERES_V
ViewGME_INV_TXN_LOTS_POSTED_ERES_V
ViewGME_INV_TXN_LOTS_TEMP_ERES_V
Package BodyGME_MOBILE_LOVS - show dependent code
Package BodyGME_MOBILE_TXN - show dependent code
PL/SQL PackageGME_PENDING_PRODUCT_LOTS_PVT - show dependent code
Package BodyGME_PENDING_PRODUCT_LOTS_PVT - show dependent code
Package BodyGME_TRANSACTIONS_PVT - show dependent code
PL/SQL PackageGMF_LOTCOSTADJUSTMENT_PUB - show dependent code
Package BodyGMF_LOTCOSTADJUSTMENT_PVT - show dependent code
Package BodyGMF_LOT_COSTING_PUB - show dependent code
PL/SQL PackageGMF_VALIDATIONS_PVT - show dependent code
Package BodyGMF_VALIDATIONS_PVT - show dependent code
Package BodyGMIVDX - show dependent code
Package BodyGMIVTDX - show dependent code
Package BodyGML_RCV_DIR_RCPT_APIS - show dependent code
PL/SQL PackageGML_RCV_TXN_INTERFACE - show dependent code
Package BodyGMO_VBATCH_TASK_PVT - show dependent code
ViewGMP_NETTABLE_ONHANDS_V
ViewICX_MTL_ONHAND_LOT_KFV
ViewINVBV_LOTS
ViewINVFV_LOTS
Package BodyINVIDIT3 - show dependent code
Package BodyINVTTMTX - show dependent code
Package BodyINV_CALCULATE_EXP_DATE - show dependent code
Package BodyINV_CONSIGNED_VALIDATIONS - show dependent code
Package BodyINV_CONVERT - show dependent code
Package BodyINV_COST_GROUP_UPDATE - show dependent code
Package BodyINV_DEFAULT_TROLIN - show dependent code
Package BodyINV_DETAIL_UTIL_PVT - show dependent code
Package BodyINV_GENEALOGY_PUB - show dependent code
Package BodyINV_GENEALOGY_REPORT_GEN - show dependent code
Package BodyINV_GMI_MIGRATION - show dependent code
Package BodyINV_GRADE_PKG - show dependent code
Package BodyINV_INV_LOVS - show dependent code
Package BodyINV_ITEM_INQ - show dependent code
Package BodyINV_LABEL - show dependent code
Package BodyINV_LABEL_PVT1 - show dependent code
Package BodyINV_LABEL_PVT10 - show dependent code
Package BodyINV_LABEL_PVT11 - show dependent code
Package BodyINV_LABEL_PVT13 - show dependent code
Package BodyINV_LABEL_PVT15 - show dependent code
Package BodyINV_LABEL_PVT2 - show dependent code
Package BodyINV_LABEL_PVT4 - show dependent code
Package BodyINV_LABEL_PVT5 - show dependent code
Package BodyINV_LABEL_PVT8 - show dependent code
Package BodyINV_LABEL_PVT9 - show dependent code
Package BodyINV_LOT_AG - show dependent code
PL/SQL PackageINV_LOT_APIS - show dependent code
Package BodyINV_LOT_APIS - show dependent code
PL/SQL PackageINV_LOT_API_PKG - show dependent code
Package BodyINV_LOT_API_PKG - show dependent code
PL/SQL PackageINV_LOT_API_PUB - show dependent code
Package BodyINV_LOT_API_PUB - show dependent code
Package BodyINV_LOT_ATTR_PUB - show dependent code
Package BodyINV_LOT_EO_PVT - show dependent code
PL/SQL PackageINV_LOT_SEL_ATTR - show dependent code
Package BodyINV_LOT_SEL_ATTR - show dependent code
Package BodyINV_LOT_SERIAL_DATE_EVENT_PKG - show dependent code
Package BodyINV_LOT_SERIAL_UPGRADE - show dependent code
Package BodyINV_LOT_TRX_VALIDATION_PUB - show dependent code
PL/SQL PackageINV_LOT_TRX_VALIDATION_PUB - show dependent code
Package BodyINV_LOT_TRX_VALIDATION_PVT - show dependent code
Package BodyINV_LPN_TRX_PUB - show dependent code
Package BodyINV_MATERIAL_STATUS_GRP - show dependent code
Package BodyINV_MATERIAL_STATUS_PKG - show dependent code
PL/SQL PackageINV_MATERIAL_STATUS_PKG - show dependent code
Package BodyINV_MATERIAL_STATUS_PUB - show dependent code
Package BodyINV_MINMAX_PVT - show dependent code
Package BodyINV_MO_LINE_DETAIL_UTIL - show dependent code
Package BodyINV_MWB_QUERY_MANAGER - show dependent code
Package BodyINV_MWB_TREE - show dependent code
Package BodyINV_MWB_TREE1 - show dependent code
Package BodyINV_OBJECT_GENEALOGY - show dependent code
Package BodyINV_OPM_LOT_MIGRATION - show dependent code
Package BodyINV_PROCESS_TEMP - show dependent code
Package BodyINV_QUANTITY_TREE_PVT - show dependent code
PL/SQL PackageINV_RCV_COMMON_APIS - show dependent code
Package BodyINV_RCV_COMMON_APIS - show dependent code
Package BodyINV_RCV_DIR_RCPT_APIS - show dependent code
Package BodyINV_RCV_INTEGRATION_APIS - show dependent code
Package BodyINV_RCV_INTEGRATION_PVT - show dependent code
Package BodyINV_RCV_STD_DELIVER_APIS - show dependent code
Package BodyINV_RCV_STD_INSPECT_APIS - show dependent code
Package BodyINV_RCV_STD_RCPT_APIS - show dependent code
Package BodyINV_RCV_STD_TRANSFER_APIS - show dependent code
Package BodyINV_RCV_TXN_INTERFACE - show dependent code
Package BodyINV_RCV_TXN_MATCH - show dependent code
PL/SQL PackageINV_RESERVATION_GLOBAL - show dependent code
Package BodyINV_RESERVATION_VALIDATE_PVT - show dependent code
PL/SQL PackageINV_ROI_INTEGRATION_GRP - show dependent code
Package BodyINV_ROI_INTEGRATION_GRP - show dependent code
Package BodyINV_SELECT_INVENTORY_PKG - show dependent code
Package BodyINV_SERIAL_PICK_PKG - show dependent code
Package BodyINV_STATUS_PKG - show dependent code
Package BodyINV_TRANSACTION_LOVS - show dependent code
Package BodyINV_TRX_UTIL_PUB - show dependent code
PL/SQL PackageINV_TRX_UTIL_PUB - show dependent code
Package BodyINV_TXN_MANAGER_GRP - show dependent code
Package BodyINV_TXN_VALIDATIONS - show dependent code
Package BodyINV_UI_ITEM_ATT_LOVS - show dependent code
Package BodyINV_UI_ITEM_LOVS - show dependent code
PL/SQL PackageINV_VALIDATE - show dependent code
Package BodyINV_VALIDATE - show dependent code
PL/SQL PackageINV_VALIDATE_TROLIN - show dependent code
Package BodyINV_VALIDATE_TROLIN - show dependent code
PL/SQL PackageLOT_SPLIT_DATA_INSERT - show dependent code
Package BodyLOT_SPLIT_DATA_INSERT - show dependent code
ViewMRPBV_PLAN_INVENTORY_LOTS
ViewMRPFV_PLAN_INVENTORY_LOTS
Package BodyMRP_HORIZONTAL_PLAN_SC - show dependent code
ViewMRP_ITEM_LOT_QUANTITIES_DET_V
ViewMRP_ITEM_LOT_QUANTITIES_V
Package BodyMRP_MRPRPROP_XMLP_PKG - show dependent code
ViewMRP_ORG_QUANTITY_DET_V
ViewMTL_ATT_QTY_V
ViewMTL_AVAILABLE_INVENTORY_V
Package BodyMTL_CCEOI_PROCESS_PVT - show dependent code
Package BodyMTL_CC_TRANSACT_PKG - show dependent code
Package BodyMTL_INV_UTIL_GRP - show dependent code
ViewMTL_ITEM_LOT_QUANTITIES_VIEW
ViewMTL_LOT_DEMAND_VAL_V
ViewMTL_LOT_ISSUES_VAL_V
ViewMTL_LOT_NUMBERS_ALL_V
ViewMTL_LOT_NUMBERS_DFV
ViewMTL_LOT_NUMBERS_ERV
Package BodyMTL_LOT_NUMBERS_PKG - show dependent code
ViewMTL_LOT_NUMBERS_SRW_V
ViewMTL_LOT_NUMBERS_VAL_V
ViewMTL_LOT_ONHAND_SUM_V
Package BodyMTL_LOT_UOM_CONV_PUB - show dependent code
Package BodyMTL_LOT_UOM_CONV_PVT - show dependent code
Package BodyMTL_MATERIAL_STATUSES_PKG - show dependent code
ViewMTL_OBJECT_NUMBERS_V
ViewMTL_ONHAND_ATP
ViewMTL_ONHAND_LOT_V
ViewMTL_ONHAND_LPN_MWB_V
ViewMTL_ONHAND_LPN_V
ViewMTL_ONHAND_NET
ViewMTL_ONHAND_NEW_LPN_MWB_V
ViewMTL_ONHAND_NEW_LPN_V
ViewMTL_ONHAND_SERIAL_MWB_V
ViewMTL_ONHAND_SERIAL_V
ViewMTL_ONHAND_TOTAL_MWB_V
ViewMTL_ONHAND_TOTAL_V
Package BodyMTL_PARAM_VALIDATE_PKG - show dependent code
ViewMTL_PENDING_TXN_DETAILS_V
ViewMTL_QOH_LOT_V
ViewMTL_RCV_MWB_NEW_OH_V
ViewMTL_RCV_SERIAL_MWB_OH_V
ViewMTL_RCV_SERIAL_OH_V
ViewMTL_RESERVATIONS_ALL_V
ViewMTL_TRANSACTION_DETAILS_V
ViewMTL_TRANSACTION_LOT_VAL_V
ViewMTL_WORK_ORDER_HEADER_V
Package BodyOE_DELAYED_REQUESTS_UTIL - show dependent code
Package BodyOE_QUERY - show dependent code
Package BodyOE_VALIDATE_LOT_SERIAL - show dependent code
Package BodyOPI_DBI_CURR_INV_EXP_PKG - show dependent code
Package BodyOPI_EDW_OPI_LOT_M_SZ - show dependent code
ViewOPI_INV_ITEM_GRADE_LVL_V
ViewOPI_INV_ITEM_LOT_LVL_V
Package BodyPJM_MASS_TRANSFER_PUB - show dependent code
Package BodyPOS_ASN_CREATE_PVT - show dependent code
ViewPOS_MTL_ONHAND_LOT_KFV
Package BodyQA_PLAN_ELEMENT_API - show dependent code
Package BodyWIP_AUTOLOTPROC_PRIV - show dependent code
Package BodyWIP_FLOW_UTILITIES - show dependent code
ViewWIP_JOB_LOT_COMPOSITION_V
Package BodyWIP_MOVE_VALIDATOR - show dependent code
Package BodyWIP_MOVPROC_PRIV - show dependent code
Package BodyWIP_SO_RESERVATIONS - show dependent code
Package BodyWIP_UTILITIES - show dependent code
Package BodyWMA_INV_WRAPPERS - show dependent code
PL/SQL PackageWMS_ASN_LOT_ATT - show dependent code
Package BodyWMS_ASN_LOT_ATT - show dependent code
Package BodyWMS_CONTAINER_PUB - show dependent code
ViewWMS_LPN_CONTENTS_LOT_V
Package BodyWMS_PACKING_WORKBENCH_PVT - show dependent code
Package BodyWMS_PUTAWAY_UTILS - show dependent code
Package BodyWMS_RETURN_SV - show dependent code
Package BodyWMS_RULE_1 - show dependent code
Package BodyWMS_RULE_11 - show dependent code
Package BodyWMS_RULE_14 - show dependent code
Package BodyWMS_RULE_15 - show dependent code
Package BodyWMS_RULE_16 - show dependent code
Package BodyWMS_RULE_17 - show dependent code
Package BodyWMS_RULE_18 - show dependent code
Package BodyWMS_RULE_2 - show dependent code
Package BodyWMS_RULE_3 - show dependent code
Package BodyWMS_RULE_4 - show dependent code
Package BodyWMS_RULE_5 - show dependent code
Package BodyWMS_RULE_6 - show dependent code
Package BodyWMS_TASK_DISPATCH_GEN - show dependent code
Package BodyWMS_TASK_DISPATCH_PUT_AWAY - show dependent code
Package BodyWMS_TXNRSN_ACTIONS_PUB - show dependent code
Package BodyWMS_UT_PKG - show dependent code
Package BodyWMS_WIP_INTEGRATION - show dependent code
Package BodyWMS_WORKFLOW_WRAPPERS - show dependent code
Package BodyWSH_DELIVERY_DETAILS_INV - show dependent code
Package BodyWSH_DELIVERY_VALIDATIONS - show dependent code
Package BodyWSH_DETAILS_VALIDATIONS - show dependent code
PL/SQL PackageWSMPINVL - show dependent code
Package BodyWSMPINVL - show dependent code
Package BodyWSMPLBJT - show dependent code
ViewWSM_DISCRETE_JOBS_LOTATTR_V
Package BodyWSM_LOTATTR_PVT - show dependent code
ViewWSM_SOURCE_LOTS_V
ViewWSM_WIP_GENEALOGY_LOTATTR_V