DBA Data[Home] [Help]

APPS.CST_ITEM_COST_IMPORT_INTERFACE dependencies on CST_ACTIVITIES

Line 268: AND NOT EXISTS( Select 1 from cst_activities ca where

264: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ACTIVITY'),1,240)
265: WHERE group_id = SEQ_NEXTVAL
266: AND ((ct.activity_id is not null ) OR (ct.activity is not null))
267: AND error_flag is null
268: AND NOT EXISTS( Select 1 from cst_activities ca where
269: NVL(ct.activity_id,ca.activity_id)= ca.activity_id AND NVL(ct.activity,ca.activity) = ca.activity
270: AND ct.organization_id = NVL(ca.organization_id,ct.organization_id)
271: AND NVL(ca.disable_date,sysdate +1) > sysdate
272: );

Line 275: ct.activity_id = (select ca.activity_id from cst_activities ca

271: AND NVL(ca.disable_date,sysdate +1) > sysdate
272: );
273:
274: Update CST_ITEM_CST_DTLS_INTERFACE ct set
275: ct.activity_id = (select ca.activity_id from cst_activities ca
276: where ca.activity = ct.activity
277: AND NVL(ca.organization_id,ct.organization_id) = ct.organization_id
278: )
279: WHERE ct.activity_id is NULL