APPS.RLM_RLMNETCH_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 56

      SELECT
        PARTY.PARTY_NAME
      FROM
        HZ_PARTIES PARTY,
        HZ_CUST_ACCOUNTS CUST_ACCT
      WHERE PARTY.PARTY_ID = CUST_ACCT.PARTY_ID
        AND CUST_ACCT.CUST_ACCOUNT_ID = V_CUSTOMER_ID;

Line: 64

      SELECT
        MEANING
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_TYPE = L_RLM_SCHEDULE_TYPE
        AND LOOKUP_CODE = V_SCHEDULE_TYPE
        AND ENABLED_FLAG = L_ENABLED_FLAG;

Line: 72

      SELECT
        SCHEDULE_REFERENCE_NUM
      FROM
        RLM_SCHEDULE_HEADERS_ALL
      WHERE HEADER_ID = V_SCH_REF_NUM;

Line: 78

      SELECT
        ORGANIZATION_CODE
      FROM
        ORG_ORGANIZATION_DEFINITIONS
      WHERE ORGANIZATION_ID = V_SHIP_FROM;

Line: 84

      SELECT
        ACCT_SITE.ECE_TP_LOCATION_CODE
      FROM
        HZ_CUST_SITE_USES_ALL CUST_SITE,
        HZ_CUST_ACCT_SITES ACCT_SITE
      WHERE CUST_SITE.SITE_USE_CODE = L_SHIP_TO
        AND ACCT_SITE.STATUS = L_STATUS
        AND CUST_SITE.SITE_USE_ID = NU_SHIP_TO
        AND ACCT_SITE.CUST_ACCT_SITE_ID = CUST_SITE.CUST_ACCT_SITE_ID
        AND CUST_SITE.ORG_ID = ACCT_SITE.ORG_ID;

Line: 95

      SELECT
        MEANING
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_TYPE = L_YES_NO
        AND LOOKUP_CODE = V_YES_NO
        AND ENABLED_FLAG = L_ENABLED_FLAG;

Line: 428

    SELECT
      ACCT_SITE.ECE_TP_LOCATION_CODE
    INTO V_INTRMD_SHIP_TO_EXT
    FROM
      HZ_CUST_ACCT_SITES ACCT_SITE
    WHERE ACCT_SITE.CUST_ACCT_SITE_ID = ITRMD_SHIP_TO_ID;

Line: 443

    SELECT
      CUSTOMER_ITEM_NUMBER
    INTO V_CUST_ITEM_NUMBER
    FROM
      MTL_CUSTOMER_ITEMS
    WHERE CUSTOMER_ITEM_ID = CUSTOMER_ITEM_ID1;

Line: 458

    SELECT
      CUSTOMER_ITEM_DESC
    INTO V_CUST_ITEM_DESC
    FROM
      MTL_CUSTOMER_ITEMS
    WHERE CUSTOMER_ITEM_ID = CUSTOMER_ITEM_ID1;

Line: 474

    SELECT
      ITEM_NUMBER
    INTO V_ITEM_NUMBER
    FROM
      MTL_ITEM_FLEXFIELDS
    WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID1
      AND ORGANIZATION_ID = SHIP_FROM_ORG_ID1;

Line: 490

    SELECT
      CUST_SITE.LOCATION
    INTO V_SHIP_TO_NAME
    FROM
      HZ_CUST_SITE_USES_ALL CUST_SITE,
      HZ_CUST_ACCT_SITES ACCT_SITE
    WHERE CUST_SITE.SITE_USE_CODE = 'SHIP_TO'
      AND CUST_SITE.SITE_USE_ID = SHIP_TO_ORG_ID1
      AND ACCT_SITE.STATUS = 'A'
      AND ACCT_SITE.CUST_ACCT_SITE_ID = CUST_SITE.CUST_ACCT_SITE_ID
      AND CUST_SITE.ORG_ID = ACCT_SITE.ORG_ID;

Line: 510

    SELECT
      ORGANIZATION_NAME
    INTO V_ORG_NAME
    FROM
      ORG_ORGANIZATION_DEFINITIONS
    WHERE ORGANIZATION_ID = SHIP_FROM_ORG_ID1;

Line: 525

    SELECT
      ORGANIZATION_NAME
    INTO V_SHIP_FROM_NAME
    FROM
      ORG_ORGANIZATION_DEFINITIONS
    WHERE ORGANIZATION_ID = SHIP_FROM_ORG_ID1;

Line: 594

    SELECT
      MEANING
    INTO V_DETAIL_TYPE
    FROM
      FND_LOOKUPS FND
    WHERE FND.LOOKUP_CODE = ITEM_DETAIL_TYPE2
      AND FND.LOOKUP_TYPE = 'RLM_DETAIL_TYPE_CODE';

Line: 610

    SELECT
      MEANING
    INTO V_DETAIL_SUBTYPE
    FROM
      FND_LOOKUPS FND
    WHERE FND.LOOKUP_CODE = ITEM_DETAIL_SUBTYPE1
      AND FND.LOOKUP_TYPE = 'RLM_DETAIL_SUBTYPE_CODE';

Line: 642

    P_LAST_CUM_QTY_UPDATE_DATE RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE := NULL;

Line: 646

    P_YESTERDAY_TIME_CUTOFF RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE := NULL;

Line: 647

    P_LAST_UPDATE_DATE RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE := NULL;

Line: 677

                                    ,X_LAST_CUM_QTY_UPDATE_DATE => P_LAST_CUM_QTY_UPDATE_DATE
                                    ,X_CUST_UOM_CODE => P_CUST_UOM_CODE
                                    ,X_USE_SHIP_INCL_RULE_FLAG => P_USE_SHIP_INCL_RULE_FLAG
                                    ,X_SHIPMENT_RULE_CODE => P_SHIPMENT_RULE_CODE
                                    ,X_YESTERDAY_TIME_CUTOFF => P_YESTERDAY_TIME_CUTOFF
                                    ,X_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE
                                    ,X_AS_OF_DATE_TIME => P_AS_OF_DATE_TIME);

Line: 706

                                           ,X_LAST_CUM_QTY_UPDATE_DATE => P_LAST_CUM_QTY_UPDATE_DATE
                                           ,X_CUST_UOM_CODE => P_CUST_UOM_CODE
                                           ,X_USE_SHIP_INCL_RULE_FLAG => P_USE_SHIP_INCL_RULE_FLAG
                                           ,X_SHIPMENT_RULE_CODE => P_SHIPMENT_RULE_CODE
                                           ,X_YESTERDAY_TIME_CUTOFF => P_YESTERDAY_TIME_CUTOFF
                                           ,X_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE
                                           ,X_AS_OF_DATE_TIME => P_AS_OF_DATE_TIME);

Line: 760

    SELECT
      START_DATE_TIME
    INTO V_CUM_START_DATE
    FROM
    RLM_SCHEDULE_LINES_ALL
    WHERE ORG_ID = CP_ORG_ID
      AND HEADER_ID = X_HEADER_ID
      AND SHIP_FROM_ORG_ID = SHIP_FROM_ORG_ID1
      AND SHIP_TO_ORG_ID = SHIP_TO_ORG_ID1
      AND CUSTOMER_ITEM_ID = CUSTOMER_ITEM_ID1
      AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID1
      AND ITEM_DETAIL_TYPE = '4'
      AND ITEM_DETAIL_SUBTYPE = 'CUM';