DBA Data[Home] [Help]

APPS.WSH_WSHRDSDL_XMLP_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 37: ORG_ORGANIZATION_DEFINITIONS

33: SELECT
34: ORGANIZATION_NAME
35: INTO REPORT_SHIP_FROM
36: FROM
37: ORG_ORGANIZATION_DEFINITIONS
38: WHERE ORGANIZATION_ID = P_SHIP_FROM_ORG_ID;
39: END IF;
40: IF (P_ORDER_TYPE IS NOT NULL) THEN
41: SELECT

Line 401: ORG_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;

397: END CF_ITEM_DISPLAYFORMULA;
398: FUNCTION CF_SHIP_FROM_ORGANIZATION_NAME(SHIP_FROM_ORGANIZATION IN NUMBER) RETURN CHAR IS
399: BEGIN
400: DECLARE
401: ORG_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
402: BEGIN
403: SELECT
404: ORGANIZATION_NAME
405: INTO ORG_NAME

Line 407: ORG_ORGANIZATION_DEFINITIONS

403: SELECT
404: ORGANIZATION_NAME
405: INTO ORG_NAME
406: FROM
407: ORG_ORGANIZATION_DEFINITIONS
408: WHERE ORGANIZATION_ID = SHIP_FROM_ORGANIZATION;
409: RETURN ORG_NAME;
410: EXCEPTION
411: WHEN OTHERS THEN