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 6331: x_cum_org_level_code IN rlm_cust_shipto_terms.cum_org_level_code%TYPE)

6327:
6328: ===========================================================================*/
6329: PROCEDURE DeriveBillToID(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
6330: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
6331: x_cum_org_level_code IN rlm_cust_shipto_terms.cum_org_level_code%TYPE)
6332: IS
6333: --
6334: CURSOR c_BillToID_ext IS --Added cursor as part of Bugfix 8672453
6335: SELECT ACCT_SITE.CUST_ACCT_SITE_ID,