APPS.GMI_ICR04_XMLP_PKG dependencies on PM_MATL_DTL

Line 18: PM_MATL_DTL M

14: SUM(T.TRANS_QTY)
15: INTO COMPLETED_TRANS_QTY
16: FROM
17: IC_TRAN_CMP T,
18: PM_MATL_DTL M
19: WHERE DOC_TYPE_1 in ( 'ADJI' , 'ADJR' , 'PICY' , 'PIPH' , 'REPI' , 'REPR' )
20: AND REASON_CODE_1 in (
21: SELECT
22: REASON_CODE

Line 63: PM_MATL_DTL M

59: SUM(T.TRANS_QTY)
60: INTO PENDING_TRANS_QTY
61: FROM
62: IC_TRAN_PND T,
63: PM_MATL_DTL M
64: WHERE T.TRANS_DATE >= FROM_DATE
65: AND T.TRANS_DATE <= TO_DATE
66: AND T.DOC_TYPE = 'PROD'
67: AND M.LINE_TYPE = - 1

Line 119: PM_MATL_DTL M

115: SUM(T.TRANS_QTY)
116: INTO COMPLETED_TRANS_QTY
117: FROM
118: IC_TRAN_CMP T,
119: PM_MATL_DTL M
120: WHERE DOC_TYPE_1 in ( 'ADJI' , 'ADJR' , 'PICY' , 'PIPH' , 'REPI' , 'REPR' )
121: AND REASON_CODE_1 in (
122: SELECT
123: REASON_CODE

Line 176: PM_MATL_DTL M

172: SUM(T.TRANS_QTY)
173: INTO PENDING_TRANS_QTY
174: FROM
175: IC_TRAN_PND T,
176: PM_MATL_DTL M
177: WHERE T.TRANS_DATE >= (
178: SELECT
179: BEGIN_DATE
180: FROM

Line 264: or (doc_type_1 ='PROD' and line_id_1 in (select line_id from pm_matl_dtl

260: begin
261: select 'TRUE' into return_flag from dual
262: where doc_type_1 in ('PORD','RECV','CREI','CRER','FPO','REQ')
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');

Line 279: or (doc_type_1 ='PROD' and line_id_1 in (select line_id from pm_matl_dtl

275: begin
276: select 'TRUE' into return_flag from dual
277: where doc_type_1 in ('OPCR','OPSO','OPSP')
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