You are browsing the archive for GML.

Oracle Process Manufacturing Logistics Tables

Oracle Process Manufacturing Logistics module – List of database tables:

  • CPG_COST_DTL
  • CPG_ORAGEMS_ARCH
  • CPG_ORAGEMS_MAPPING
  • CPG_PURCHASING_ARCH
  • CPG_PURCHASING_INTERFACE
  • GML_BATCH_SO_ALLOC_HISTORY
  • GML_BATCH_SO_RESERVATIONS
  • GML_BATCH_SO_RULES
  • GML_BATCH_SO_RULE_ASSIGNMENTS
  • GML_BATCH_SO_WORKFLOW
  • GML_BATCH_TMP
  • GML_GASNO_DETAILS
  • GML_GASNO_DETAILS_X
  • GML_GASNO_DETAIL_ALLOCATIONS
  • GML_GASNO_DETAIL_ALLOCATIONS_X
  • GML_GASNO_DETAIL_CHARGES
  • GML_GASNO_DETAIL_CHARGES_X
  • GML_GASNO_DETAIL_TEXT
  • GML_GASNO_DETAIL_TEXT_X
  • GML_GASNO_ORDERS
  • GML_GASNO_ORDERS_X
  • GML_GASNO_ORDER_CHARGES
  • GML_GASNO_ORDER_CHARGES_X
  • GML_GASNO_ORDER_TEXT
  • GML_GASNO_ORDER_TEXT_X
  • GML_GASNO_SHIPMENTS
  • GML_GASNO_SHIPMENTS_X
  • GML_GASNO_SHIPMENT_TEXT
  • GML_GASNO_SHIPMENT_TEXT_X
  • GML_GPOAO_DETAILS
  • GML_GPOAO_DETAILS_X
  • GML_GPOAO_DETAIL_ALLOCATIONS
  • GML_GPOAO_DETAIL_ALLOCATIONS_X
  • GML_GPOAO_DETAIL_CHARGES
  • GML_GPOAO_DETAIL_CHARGES_X
  • GML_GPOAO_DETAIL_TEXT
  • GML_GPOAO_DETAIL_TEXT_X
  • GML_GPOAO_ORDERS
  • GML_GPOAO_ORDERS_X
  • GML_GPOAO_ORDER_CHARGES
  • GML_GPOAO_ORDER_CHARGES_X
  • GML_GPOAO_ORDER_TEXT
  • GML_GPOAO_ORDER_TEXT_X
  • GML_INVALID_CUSTOMERS
  • GML_PO_MIG_ERRORS
  • GML_RCV_LOTS_MIGRATION
  • GML_RECV_ADJUST_ERRORS
  • GML_RECV_TRANS_MAP
  • OP_ALOT_PRM
  • OP_AUDT_DTL
  • OP_AUDT_MST
  • OP_BILL_LAD
  • OP_CGLD_CLS
  • OP_CHRG_BRK
  • OP_CHRG_CLS
  • OP_CHRG_ITM
  • OP_CHRG_MST
  • OP_CNTR_BRK
  • OP_CNTR_DTL
  • OP_CNTR_HDR
  • OP_CNTR_HDR_EFC
  • OP_COMMISSION
  • OP_COMM_CDS
  • OP_CPRC_CLS
  • OP_CTRD_CLS
  • OP_CUST_ASC
  • OP_CUST_CLS
  • OP_CUST_CON
  • OP_CUST_CON_INT
  • OP_CUST_ITM
  • OP_CUST_MST
  • OP_CUST_MST_INT
  • OP_CUST_MST_OPM
  • OP_CUST_SHP
  • OP_FOBC_MST
  • OP_FOBC_MST_INT
  • OP_FRGT_MTH
  • OP_GNRC_ITM
  • OP_HOLD_CDS
  • OP_INVC_CHG
  • OP_LKBX_MST
  • OP_ORDR_CHG
  • OP_ORDR_DAC_INTERFACE
  • OP_ORDR_DTL
  • OP_ORDR_DTL_EFC
  • OP_ORDR_DTL_INTERFACE
  • OP_ORDR_DTX_INTERFACE
  • OP_ORDR_HAC_INTERFACE
  • OP_ORDR_HDR
  • OP_ORDR_HDR_INTERFACE
  • OP_ORDR_HTX_INTERFACE
  • OP_ORDR_STS_B
  • OP_ORDR_STS_TL
  • OP_ORDR_TYPE_MIGRATION
  • OP_ORDR_TYP_B
  • OP_ORDR_TYP_TL
  • OP_PKGD_ITM
  • OP_PORT_MST
  • OP_PRCE_BRK
  • OP_PRCE_CDS
  • OP_PRCE_EFF
  • OP_PRCE_ITM
  • OP_PRCE_MST
  • OP_PRSL_AUD
  • OP_PRSL_CHG
  • OP_PRSL_DTL
  • OP_PRSL_DTL_EFC
  • OP_PRSL_HDR
  • OP_PRSL_HDR_EFC
  • OP_PRSL_MOD
  • OP_PRSL_TYP_B
  • OP_PRSL_TYP_TL
  • OP_RELS_SCH
  • OP_SHIP_MST
  • OP_SHIP_MTH
  • OP_SLSR_CLS
  • OP_SLSR_MST
  • OP_SLSR_MST_INT
  • OP_TERM_MST
  • OP_TERM_MST_INT
  • OP_TEXT_HDR
  • OP_TEXT_TBL_TL
  • OP_TRAN_TMP
  • OP_TXCU_ASC
  • OP_UPDT_BAL_WK
  • PO_BPOS_DTL
  • PO_BPOS_HDR
  • PO_BPOS_HDR_EFC
  • PO_COST_DTL
  • PO_COST_MST
  • PO_DIST_DTL
  • PO_DIST_DTL_EFC
  • PO_ORDR_DTL
  • PO_ORDR_HDR
  • PO_ORDR_HDR_EFC
  • PO_RECV_DTL
  • PO_RECV_HDR
  • PO_RECV_HDR_EFC
  • PO_RECV_HST
  • PO_RECV_HST_EFC
  • PO_RELS_SCH
  • PO_RTRN_DTL
  • PO_RTRN_HDR
  • PO_TEXT_HDR
  • PO_TEXT_TBL_TL
  • PO_VEND_ASC
  • PO_VEND_CLS
  • PO_VEND_MST
  • PO_VEND_MST_INT
  • PO_VGLD_CLS
  • PO_VNIT_MST
  • PO_VTRD_CLS
  • TX_CALC_MST
  • TX_HIST_TAX
  • TX_TAXA_DTL
  • TX_TAXA_MST
  • TX_TAXA_STS
  • TX_TEXT_HDR
  • TX_TEXT_TBL_TL
  • TX_TLOC_ASC
  • TX_TLOC_CDS
  • TX_TOFR_ASC
  • TX_TXRE_CDS
  • TX_TXRP_CLS

Process Manufacturing Logistics Forms

Oracle Process Manufacturing Logistics Forms:

OPALOTED Allocation Criteria
OPBILLDB Invoice History
OPBOAUR1 Blanket Order Auto Release
OPBOED1 Blanket Sales Order
OPCCLSED Customer Class
OPCGLCED Customer GL Class
OPCHGED Charge
OPCNTED Contract
OPCOMMED Commission Codes
OPCPRED Customer Price Class
OPCRCKDB Order Hold Maintenance
OPCTCLED Customer Trade Class
OPCUSED1 Customer Maintenance
OPEFFLST Price Effectivity Search
OPFOBCED FOB Codes
OPFRMTED Freight Bill Methods
OPGENED OP Generic Items
OPHRCED Hold Reason Codes
OPLBXED Lock Box
OPLOTAL Shipping Pick lots
OPLOTUP4 OP Pending Transactions
OPOPED1 Order Profiles
OPOSTED Order Status
OPPCHDB1 OP Mass Change
OPPCRED Price Reasons
OPPKMN1 Packaged Item
OPPLSED Price List
OPPORTED Shipping/Receiving Ports
OPPRCEFF Price List Effectivity
OPREPRED Shipment Re-Pricing
OPSHIPED Customer Association
OPSHMHED Shipping Methods
OPSHPED Carrier
OPSHPED1 Shipping
OPSHPED8 Shipping History
OPSLSRCL Sales Representative Class
OPSLSRED Sales Representative
OPSOED1 Open Sales Order
OPTERMED Terms Codes
OPTYPED Order Type
OPXANED1 Charge Class
OPXEXED1 Customer Tax Exempt
POGENED Generic Items
POGLCED Vendor GL Class
POGLDED2 PO GL Account Distribution
POLOTUP2 PO Completed Transactions
POLOTUP4 PO Pending Transactions
POPACED Acquisition Cost Setup
POPACED2 PO Line Level Acquisition Cost
POQRCED Quick Receipts
PORCVED1 PO Receiving
PORTNQK1 Returns
POSRTED Stock Receipts
POVDCLED Vendor Class
POVTCLED Vendor Trade Class
SOALKUP Sales Pick Lots
SOLOTUP4 Sales Manual Allocations
TXXASED1 Location Authority Association
TXXAUED1 Tax Authority Rates
TXXCLED1 Tax Calculation
TXXLOED1 Tax Location Codes
TXXRCED1 Exempt Reason Codes
TXXRPED1 Reporting Classes
TXXSTED1 Tax Status

Process Manufacturing Logistics Profile Options

Oracle Process Manufacturing Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
OP$ALLOC_ENTIRE_QTY2 GML: Allocate Entire Qty2 with Qty1
GML_OM_INTEGRATION GML: OM Integration
OP$RESTRICT_PICKLOTS GML: Restrict Lots For Picking
GML$DEL_ALC_BEFORE_AUTO GML: Delete Existing Allocations
GML_USE_CREATION_DATE GML: Use Creation Date as Transaction Date
GML_ENABLE_DYN_LOT_SPEC_CONV GML: Enable Lot Specific Conversion
GML_SHOW_PRE_GRADE GML: Preferred grade only in manual allocation
OP$BSO_ACCUM_REL GML: Use Accumulated BSO Pricing
OP$ORDERS_PER_RELEASE GML: Number of Sales Order Per BSO Release
GML_DATE_CHK GML: Override Date Check
OP$ALLOC_COMMIT GML: Commit Allocations
PO$DEF_DATE GML: Creation Date on Purchase Order
OP$LOCK_THRESHOLD GML: Lock Threshold
GML_CHK_INV_PICK_REL GML: Check onhand INV when releasing OM to whse
OP$OVERRIDE_IN_PRICE_UM GML: Override Price in Price UM
OP$SALESRTN GML : Enable Returns Option
PO$CANCEL_CODE GML: Default PO Cancel Reason Code