DBA Data[Home] [Help]

APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on WSH_DELIVERY_DETAILS

Line 1596: FROM wsh_delivery_details

1592: CURSOR Fetch_OE_Address_Cur IS
1593: SELECT cust_acct_site_id address_id
1594: from hz_cust_site_uses_all where site_use_id=
1595: (select SHIP_TO_LOCATION_ID
1596: FROM wsh_delivery_details
1597: WHERE delivery_detail_id = p_ref_line_id);
1598:
1599: CURSOR Fetch_AR_Address_Cur IS
1600: SELECT cust_acct_site_id address_id

Line 1671: FROM wsh_delivery_details

1667: RETURN NUMBER IS
1668:
1669: CURSOR c_get_order_line_id(cp_delivery_detail_id IN NUMBER) IS
1670: SELECT source_line_id
1671: FROM wsh_delivery_details
1672: WHERE delivery_detail_id = cp_delivery_detail_id;
1673:
1674: CURSOR c_oe_excise_cess_cnt(cp_order_line_id IN NUMBER) IS
1675: SELECT count(1)