DBA Data[Home] [Help]

APPS.CSI_ORDER_SHIP_PUB dependencies on CSI_I_ORG_ASSIGNMENTS

Line 7686: FROM csi_i_org_assignments

7682: IF nvl(p_txn_line_detail_tbl(i).instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
7683: BEGIN
7684: SELECT 'X'
7685: INTO l_sold_from_org_found
7686: FROM csi_i_org_assignments
7687: WHERE instance_id = p_txn_line_detail_tbl(i).instance_id
7688: AND operating_unit_id = p_order_line_rec.sold_from_org_id
7689: AND relationship_type_code = 'SOLD_FROM'
7690: AND nvl (active_end_date, sysdate+1) > sysdate;