DBA Data[Home] [Help]

APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on WSH_DELIVERY_DETAILS

Line 1687: FROM wsh_delivery_details

1683: CURSOR Fetch_OE_Address_Cur IS
1684: SELECT cust_acct_site_id address_id
1685: from hz_cust_site_uses_all where site_use_id=
1686: (select SHIP_TO_LOCATION_ID
1687: FROM wsh_delivery_details
1688: WHERE delivery_detail_id = p_ref_line_id);
1689:
1690: CURSOR Fetch_AR_Address_Cur IS
1691: SELECT cust_acct_site_id address_id

Line 1766: FROM wsh_delivery_details

1762: RETURN NUMBER IS
1763:
1764: CURSOR c_get_order_line_id(cp_delivery_detail_id IN NUMBER) IS
1765: SELECT source_line_id
1766: FROM wsh_delivery_details
1767: WHERE delivery_detail_id = cp_delivery_detail_id;
1768:
1769: CURSOR c_oe_excise_cess_cnt(cp_order_line_id IN NUMBER) IS
1770: SELECT count(1)