eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TYPE: APPS.PO_SHIPMENTS_REC_TYPE

Object Details

Object Name:	PO_SHIPMENTS_REC_TYPE
Object Type:	TYPE
Owner:	APPS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length	Prcn
PO_LINE_LOCATION_ID	PO_TBL_NUMBER
QUANTITY	PO_TBL_NUMBER
PROMISED_DATE	PO_TBL_DATE
PRICE_OVERRIDE	PO_TBL_NUMBER
PARENT_LINE_LOCATION_ID	PO_TBL_NUMBER
SPLIT_SHIPMENT_NUM	PO_TBL_NUMBER
NEED_BY_DATE	PO_TBL_DATE
SHIP_TO_LOCATION_ID	PO_TBL_NUMBER
SALES_ORDER_UPDATE_DATE	PO_TBL_DATE
AMOUNT	PO_TBL_NUMBER
REQUEST_UNIT_OF_MEASURE	PO_TBL_VARCHAR30
SECONDARY_QUANTITY	PO_TBL_NUMBER
REQUEST_SECONDARY_UOM	PO_TBL_VARCHAR30
DELETE_RECORD	PO_TBL_VARCHAR1
PREFERRED_GRADE	PO_TBL_VARCHAR240
PAYMENT_TYPE	PO_TBL_VARCHAR30
DESCRIPTION	PO_TBL_VARCHAR240
NEW_SUPP_ORDER_LINE_NO	PO_TBL_VARCHAR25
C_PO_LINE_ID	PO_TBL_NUMBER
C_QUANTITY	PO_TBL_NUMBER
C_UNIT_MEAS_LOOKUP_CODE	PO_TBL_VARCHAR30
C_CANCEL_FLAG	PO_TBL_VARCHAR1
C_CLOSED_CODE	PO_TBL_VARCHAR30
C_ITEM_ID	PO_TBL_NUMBER
C_SHIP_TO_ORGANIZATION_ID	PO_TBL_NUMBER
C_DROP_SHIP_FLAG	PO_TBL_VARCHAR1
C_QUANTITY_RECEIVED	PO_TBL_NUMBER
C_QUANTITY_BILLED	PO_TBL_NUMBER
C_AMOUNT_RECEIVED	PO_TBL_NUMBER
C_AMOUNT_BILLED	PO_TBL_NUMBER
C_ACCRUE_ON_RECEIPT_FLAG	PO_TBL_VARCHAR1
C_VALUE_BASIS	PO_TBL_VARCHAR30
C_PURCHASE_BASIS	PO_TBL_VARCHAR30
C_AMOUNT	PO_TBL_NUMBER
C_PRICE_OVERRIDE	PO_TBL_NUMBER
C_PARENT_QUANTITY	PO_TBL_NUMBER
C_PARENT_AMOUNT	PO_TBL_NUMBER
C_SECONDARY_QUANTITY	PO_TBL_NUMBER
C_SECONDARY_UOM	PO_TBL_VARCHAR30
C_ITEM_NUMBER	PO_TBL_VARCHAR40
C_APPROVED_DATE	PO_TBL_DATE
C_ENCUMBERED_FLAG	PO_TBL_VARCHAR1
C_SHIPMENT_TYPE	PO_TBL_VARCHAR30
C_QUANTITY_SHIPPED	PO_TBL_NUMBER
C_PREFERRED_GRADE	PO_TBL_VARCHAR240
C_PAYMENT_TYPE	PO_TBL_VARCHAR30
T_FROM_PRICE_BREAK	PO_TBL_VARCHAR1
T_MANUAL_PRICE_CHANGE_FLAG	PO_TBL_VARCHAR1
T_SEC_QTY_GRADE_CHANGE_ONLY	PO_TBL_VARCHAR1

Methods

Name	Parameters	Result
CREATE_OBJECT	P_PO_LINE_LOCATION_ID(PO_TBL_NUMBER) P_QUANTITY(PO_TBL_NUMBER) P_PROMISED_DATE(PO_TBL_DATE) P_PRICE_OVERRIDE(PO_TBL_NUMBER) P_PARENT_LINE_LOCATION_ID(PO_TBL_NUMBER) P_SPLIT_SHIPMENT_NUM(PO_TBL_NUMBER) P_NEED_BY_DATE(PO_TBL_DATE) P_SHIP_TO_LOCATION_ID(PO_TBL_NUMBER) P_SALES_ORDER_UPDATE_DATE(PO_TBL_DATE) P_AMOUNT(PO_TBL_NUMBER) P_REQUEST_UNIT_OF_MEASURE(PO_TBL_VARCHAR30) P_SECONDARY_QUANTITY(PO_TBL_NUMBER) P_REQUEST_SECONDARY_UOM(PO_TBL_VARCHAR30) P_DELETE_RECORD(PO_TBL_VARCHAR1) P_PAYMENT_TYPE(PO_TBL_VARCHAR30) P_DESCRIPTION(PO_TBL_VARCHAR240) P_NEW_SUPP_ORDER_LINE_NO(PO_TBL_VARCHAR25)	PO_SHIPMENTS_REC_TYPE
ADD_CHANGE	SELF(PO_SHIPMENTS_REC_TYPE) P_PO_LINE_LOCATION_ID(NUMBER) P_QUANTITY(NUMBER) P_PROMISED_DATE(DATE) P_PRICE_OVERRIDE(NUMBER) P_PARENT_LINE_LOCATION_ID(NUMBER) P_SPLIT_SHIPMENT_NUM(NUMBER) P_NEED_BY_DATE(DATE) P_SHIP_TO_LOCATION_ID(NUMBER) P_SALES_ORDER_UPDATE_DATE(DATE) P_AMOUNT(NUMBER) P_REQUEST_UNIT_OF_MEASURE(VARCHAR2) P_SECONDARY_QUANTITY(NUMBER) P_REQUEST_SECONDARY_UOM(VARCHAR2) P_DELETE_RECORD(VARCHAR2) P_PREFERRED_GRADE(VARCHAR2) P_PAYMENT_TYPE(VARCHAR2) P_DESCRIPTION(VARCHAR2) P_NEW_SUPP_ORDER_LINE_NO(VARCHAR2)
EXTEND_FIELDS	SELF(PO_SHIPMENTS_REC_TYPE) L_EXTEND_SIZE(NUMBER)
GET_COUNT	SELF(PO_SHIPMENTS_REC_TYPE)	NUMBER
SET_QUANTITY	SELF(PO_SHIPMENTS_REC_TYPE) P_INDEX(NUMBER) P_QUANTITY(NUMBER)
SET_PRICE_OVERRIDE	SELF(PO_SHIPMENTS_REC_TYPE) P_INDEX(NUMBER) P_PRICE_OVERRIDE(NUMBER)
SET_AMOUNT	SELF(PO_SHIPMENTS_REC_TYPE) P_INDEX(NUMBER) P_AMOUNT(NUMBER)
SET_GRADE_FLAG	SELF(PO_SHIPMENTS_REC_TYPE) P_INDEX(NUMBER) P_FLAG(VARCHAR2)
DUMP_TO_LOG	SELF(PO_SHIPMENTS_REC_TYPE)

Dependencies

[top of page]

APPS.PO_SHIPMENTS_REC_TYPE references the following:

APPS: PO_TBL_DATE; PO_TBL_NUMBER; PO_TBL_VARCHAR1; PO_TBL_VARCHAR240; PO_TBL_VARCHAR25; PO_TBL_VARCHAR30; PO_TBL_VARCHAR40
SYS: STANDARD - show dependent code

APPS.PO_SHIPMENTS_REC_TYPE is referenced by following:

APPS: CSP_REPAIR_PO_PVT - show dependent code; MRP_PO_RESCHEDULE - show dependent code; PO_CHANGES_REC_TYPE; PO_CHANGES_REC_TYPE; PO_CHANGE_RESPONSE_PVT - show dependent code; PO_CHG_REQUEST_PVT - show dependent code; PO_DOCUMENT_CHECKS_PVT - show dependent code; PO_DOCUMENT_UPDATE_GRP - show dependent code; PO_DOCUMENT_UPDATE_PVT - show dependent code; PO_OM_INTEGRATION_GRP - show dependent code; PO_RESCHEDULE_PKG - show dependent code; PO_SHIPMENTS_REC_TYPE; WIP_OSP - show dependent code