[Home] [Help] [Dependency Information]
Object Name: | IGI_STP_SITE_BAL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGI.IGI_STP_SITE_BAL |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
View lists single third party site information
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STP_ID | NUMBER | (15) | Yes | Single third party identifier |
ADDRESS_ID | NUMBER | (15) | Yes | Receivables Address identifier |
ADDRESS_NAME | VARCHAR2 | (100) | Receivable Address name | |
VENDOR_ID | NUMBER | Yes | Supplier identifier | |
VENDOR_SITE_ID | NUMBER | Yes | Supplier site identifier | |
ORG_ID | NUMBER | (15) | organization Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT STP_ID
, ADDRESS_ID
, ADDRESS_NAME
, VENDOR_ID
, VENDOR_SITE_ID
, ORG_ID
FROM APPS.IGI_STP_SITE_BAL;
APPS.IGI_STP_SITE_BAL is not referenced by any database object
|
|
|