DBA Data[Home] [Help]

APPS.WSH_OPSM_ASN_BE_PKG dependencies on WSH_OPSM_ASN_ITEMS_V

Line 84: FROM wsh_opsm_asn_items_v

80:
81: CURSOR cur_item
82: IS
83: SELECT *
84: FROM wsh_opsm_asn_items_v
85: WHERE delivery_id=p_delivery_id
86: AND delivery_detail_id = p_delivery_detail_id;
87:
88: CURSOR cur_container(p_delivery_id IN NUMBER,

Line 1157: FROM wsh_opsm_asn_items_v

1153:
1154: CURSOR cur_item
1155: IS
1156: SELECT *
1157: FROM wsh_opsm_asn_items_v
1158: WHERE delivery_id=p_delivery_id;
1159:
1160: CURSOR cur_container(p_delivery_id IN NUMBER,
1161: p_container_instance_id IN NUMBER)

Line 2167: FROM wsh_opsm_asn_items_v

2163: l_debug_on BOOLEAN;
2164: CURSOR c_opsm_items
2165: IS
2166: SELECT item_id ,organization_id
2167: FROM wsh_opsm_asn_items_v
2168: WHERE delivery_id=(l_delivery_id);
2169:
2170: BEGIN
2171: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;