DBA Data[Home] [Help]

APPS.CSM_REQUIREMENTS_PKG dependencies on ASG_DEFERRED_TRANINFO

Line 45: AND NOT EXISTS(SELECT 1 FROM ASG_DEFERRED_TRANINFO a --hz_location pkg can defer hdr/lines

41: AND reql.clid$$cs = reqh.clid$$cs
42: AND reql.tranid$$ = b_tranid
43: AND reql.clid$$cs = b_user_name
44: AND reql.requirement_header_id = reqh.requirement_header_id
45: AND NOT EXISTS(SELECT 1 FROM ASG_DEFERRED_TRANINFO a --hz_location pkg can defer hdr/lines
46: WHERE device_user_name=reqh.clid$$cs
47: AND deferred_tran_id=reqh.tranid$$
48: AND SEQUENCE=reqh.seqno$$);
49:

Line 307: AND NOT EXISTS(SELECT 1 FROM ASG_DEFERRED_TRANINFO a --hz_location pkg can also defer hdr/lines

303: WHERE l.tranid$$ = b_tranid
304: AND l.clid$$cs = b_user_name
305: AND l.requirement_header_id = h.requirement_header_id
306: )
307: AND NOT EXISTS(SELECT 1 FROM ASG_DEFERRED_TRANINFO a --hz_location pkg can also defer hdr/lines
308: WHERE device_user_name=b_user_name
309: AND deferred_tran_id=b_tranid
310: AND SEQUENCE=h.seqno$$);
311: