458: l_currency_code VARCHAR2(30);
459: l_inventory_org_id NUMBER;
460: l_header_org_id NUMBER;
461: l_conversion_rate NUMBER;
462: l_cust_trx_type_id ra_cust_trx_types_all.cust_Trx_type_id%type;
463: l_legal_entity_id NUMBER(15);
464: l_ship_party_id NUMBER(15);
465: l_ship_party_site_id NUMBER(15);
466: l_ship_location_id NUMBER(15);
725: SELECT
726: /* MOAC_SQL_CHANGE */
727: NVL(cust_type.subsequent_trx_type_id, cust_type.cust_trx_type_id)
728: INTO l_cust_trx_type_id
729: FROM ra_cust_trx_types_all cust_type,
730: ra_customer_trx cust_trx
731: WHERE cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
732: AND cust_type.org_id = cust_trx.org_id
733: AND cust_trx.customer_trx_id = l_commitment_id;
891: SELECT
892: /* MOAC_SQL_CHANGE */
893: NVL(cust_type.subsequent_trx_type_id, cust_type.cust_trx_type_id)
894: INTO l_cust_trx_type_id
895: FROM ra_cust_trx_types_all cust_type,
896: ra_customer_trx cust_trx
897: WHERE cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
898: AND cust_type.org_id = cust_trx.org_id
899: AND cust_trx.customer_trx_id = l_commitment_id;