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 367: ORG_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;

363: END CF_ITEM_DISPLAYFORMULA;
364: FUNCTION CF_SHIP_FROM_ORGANIZATION_NAME(SHIP_FROM_ORGANIZATION IN NUMBER) RETURN CHAR IS
365: BEGIN
366: DECLARE
367: ORG_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
368: BEGIN
369: SELECT
370: ORGANIZATION_NAME
371: INTO ORG_NAME

Line 373: ORG_ORGANIZATION_DEFINITIONS

369: SELECT
370: ORGANIZATION_NAME
371: INTO ORG_NAME
372: FROM
373: ORG_ORGANIZATION_DEFINITIONS
374: WHERE ORGANIZATION_ID = SHIP_FROM_ORGANIZATION;
375: RETURN ORG_NAME;
376: EXCEPTION
377: WHEN OTHERS THEN