APPS.GMI_ICR04_XMLP_PKG dependencies on SY_REAS_CDS

Line 24: SY_REAS_CDS

20: AND REASON_CODE_1 in (
21: SELECT
22: REASON_CODE
23: FROM
24: SY_REAS_CDS
25: WHERE FLOW_TYPE = 0 )
26: AND T.TRANS_DATE >= FROM_DATE
27: AND T.TRANS_DATE <= TO_DATE
28: AND T.DOC_TYPE = 'PROD'

Line 44: SY_REAS_CDS R

40: SUM(T.TRANS_QTY)
41: INTO REAS_TRANS_QTY
42: FROM
43: IC_TRAN_CMP T,
44: SY_REAS_CDS R
45: WHERE T.TRANS_DATE >= FROM_DATE
46: AND T.TRANS_DATE <= TO_DATE
47: AND R.FLOW_TYPE = 0
48: AND T.REASON_CODE = R.REASON_CODE

Line 84: SY_REAS_CDS R

80: SUM(T.TRANS_QTY)
81: INTO REASP_TRANS_QTY
82: FROM
83: IC_TRAN_PND T,
84: SY_REAS_CDS R
85: WHERE T.TRANS_DATE >= FROM_DATE
86: AND T.TRANS_DATE <= TO_DATE
87: AND R.FLOW_TYPE = 0
88: AND T.REASON_CODE = R.REASON_CODE

Line 125: SY_REAS_CDS

121: AND REASON_CODE_1 in (
122: SELECT
123: REASON_CODE
124: FROM
125: SY_REAS_CDS
126: WHERE FLOW_TYPE = 0 )
127: AND T.TRANS_DATE >= (
128: SELECT
129: BEGIN_DATE

Line 151: SY_REAS_CDS R

147: SUM(T.TRANS_QTY)
148: INTO REAS_TRANS_QTY
149: FROM
150: IC_TRAN_CMP T,
151: SY_REAS_CDS R
152: WHERE T.TRANS_DATE >= (
153: SELECT
154: BEGIN_DATE
155: FROM

Line 203: SY_REAS_CDS R

199: SUM(T.TRANS_QTY)
200: INTO REASP_TRANS_QTY
201: FROM
202: IC_TRAN_PND T,
203: SY_REAS_CDS R
204: WHERE T.TRANS_DATE >= (
205: SELECT
206: BEGIN_DATE
207: FROM

Line 251: where reason_code_1 in (select reason_code from sy_reas_cds where flow_type in (1,-1));

247: return_flag varchar2(4);
248: begin
249: if doc_type_1 in ('ADJI','ADJR') then
250: select 'TRUE' into return_flag from dual
251: where reason_code_1 in (select reason_code from sy_reas_cds where flow_type in (1,-1));
252: end if;
253: return('true');
254: exception
255: when no_data_found then

Line 267: in (select reason_code from sy_reas_cds where flow_type=1)) ;

263: or (doc_type_1 in ('TRNI','TRNR')and quantity_1 > 0)
264: or (doc_type_1 ='PROD' and line_id_1 in (select line_id from pm_matl_dtl
265: where line_type in (1,2) and batch_id = doc_id_1 and line_id=line_id_1))
266: or (doc_type_1 in ('ADJI','ADJR','PICY','PIPH','REPI','REPR') and reason_code_1
267: in (select reason_code from sy_reas_cds where flow_type=1)) ;
268: return ('TRUE');
269: RETURN NULL; exception when no_data_found then
270: return('FALSE');
271: end;

Line 282: in (select reason_code from sy_reas_cds where flow_type=-1)) ;

278: or (doc_type_1 in ('TRNI','TRNR','MTRI')and quantity_1 < 0)
279: or (doc_type_1 ='PROD' and line_id_1 in (select line_id from pm_matl_dtl
280: where line_type =-1 and batch_id = doc_id_1 and line_id=line_id_1))
281: or (doc_type_1 in ('ADJI','ADJR','PICY','PIPH','REPI','REPR') and reason_code_1
282: in (select reason_code from sy_reas_cds where flow_type=-1)) ;
283: if sql%found then
284: return ('TRUE');
285: else
286: return('FALSE');