DBA Data[Home] [Help]

APPS.RLM_VALIDATEDEMAND_SV dependencies on RLM_CUST_SHIPTO_TERMS

Line 5862: FROM rlm_cust_shipto_terms t

5858: END IF;
5859: --
5860: SELECT ship_from_org_id
5861: INTO x_lines_rec.ship_from_org_id
5862: FROM rlm_cust_shipto_terms t
5863: WHERE customer_id = x_header_rec.customer_id
5864: AND address_id = nvl(x_lines_rec.ship_to_address_id,address_id)
5865: AND cust_assign_supplier_cd =
5866: x_lines_rec.cust_ship_from_org_ext;

Line 5887: FROM rlm_cust_shipto_terms t

5883: END IF;
5884: --
5885: SELECT ship_from_org_id
5886: INTO x_lines_rec.ship_from_org_id
5887: FROM rlm_cust_shipto_terms t
5888: WHERE customer_id = x_header_rec.customer_id AND
5889: address_id IS NULL AND
5890: cust_assign_supplier_cd =
5891: x_lines_rec.cust_ship_from_org_ext;

Line 6308: x_cum_org_level_code IN rlm_cust_shipto_terms.cum_org_level_code%TYPE)

6304:
6305: ===========================================================================*/
6306: PROCEDURE DeriveBillToID(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
6307: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
6308: x_cum_org_level_code IN rlm_cust_shipto_terms.cum_org_level_code%TYPE)
6309: IS
6310: --
6311: v_progress VARCHAR2(3) := '010';
6312: v_count NUMBER;