DBA Data[Home] [Help]

APPS.CSI_ORDER_SHIP_PUB dependencies on CSI_I_ORG_ASSIGNMENTS

Line 7367: FROM csi_i_org_assignments

7363: IF nvl(p_txn_line_detail_tbl(i).instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
7364: BEGIN
7365: SELECT 'X'
7366: INTO l_sold_from_org_found
7367: FROM csi_i_org_assignments
7368: WHERE instance_id = p_txn_line_detail_tbl(i).instance_id
7369: AND operating_unit_id = p_order_line_rec.sold_from_org_id
7370: AND relationship_type_code = 'SOLD_FROM'
7371: AND nvl (active_end_date, sysdate+1) > sysdate;