APPS.GMIALLOC dependencies on OP_ORDR_DTL

Line 102: from ic_tran_pnd pnd, op_ordr_dtl ordr, op_hold_cds hold

98: and matl.phantom_id IS NULL
99: UNION ALL
100: select trans_id,pnd.item_id,lot_id,whse_code,location,qc_grade,trans_qty,
101: trans_qty2,doc_type,doc_id,pnd.line_id
102: from ic_tran_pnd pnd, op_ordr_dtl ordr, op_hold_cds hold
103: where pnd.item_id = pcur_get_trans_cmp.item_id
104: and pnd.lot_id = pcur_get_trans_cmp.lot_id
105: and pnd.whse_code = pcur_get_trans_cmp.whse_code
106: and pnd.location = pcur_get_trans_cmp.location

Line 151: UPDATE_OP_ORDR_DTL VARCHAR2(1);

147: and staged_ind = 0
148: and whse_code = pto_whse_code;
149:
150: orderid NUMBER;
151: UPDATE_OP_ORDR_DTL VARCHAR2(1);
152: l_user_id NUMBER := FND_GLOBAL.user_id;
153:
154: /*====================End of Variable Declarations==============================*/
155: BEGIN

Line 187: UPDATE_OP_ORDR_DTL := 'Y';

183: where order_id = Cur_get_trans_pnd_rec.doc_id
184: and delete_mark = 0
185: FOR UPDATE NOWAIT;
186:
187: UPDATE_OP_ORDR_DTL := 'Y';
188: EXCEPTION
189: WHEN OTHERS THEN
190: UPDATE_OP_ORDR_DTL := 'N';
191: END;--}

Line 190: UPDATE_OP_ORDR_DTL := 'N';

186:
187: UPDATE_OP_ORDR_DTL := 'Y';
188: EXCEPTION
189: WHEN OTHERS THEN
190: UPDATE_OP_ORDR_DTL := 'N';
191: END;--}
192: END IF;--}
193: END IF;--}
194: --{

Line 198: OR (UPDATE_OP_ORDR_DTL = 'Y')

194: --{
195: IF ( (Cur_get_trans_pnd_rec.doc_type <> 'OPSO')
196: OR ( (Cur_get_trans_pnd_rec.doc_type = 'OPSO')
197: AND ( (Cur_get_trans_cmp_rec.whse_code = pto_whse_code)
198: OR (UPDATE_OP_ORDR_DTL = 'Y')
199: )
200: )
201: ) THEN
202:

Line 213: AND (UPDATE_OP_ORDR_DTL = 'Y')

209: END IF;--}
210: --{
211: IF ( (Cur_get_trans_pnd_rec.doc_type = 'OPSO')
212: AND (Cur_get_trans_cmp_rec.whse_code <> pto_whse_code)
213: AND (UPDATE_OP_ORDR_DTL = 'Y')
214: ) THEN
215:
216: UPDATE OP_ORDR_DTL
217: SET FROM_WHSE = pto_whse_code,

Line 216: UPDATE OP_ORDR_DTL

212: AND (Cur_get_trans_cmp_rec.whse_code <> pto_whse_code)
213: AND (UPDATE_OP_ORDR_DTL = 'Y')
214: ) THEN
215:
216: UPDATE OP_ORDR_DTL
217: SET FROM_WHSE = pto_whse_code,
218: LAST_UPDATED_BY = l_user_id,
219: LAST_UPDATE_DATE = SYSDATE
220: WHERE line_id = Cur_get_trans_pnd_rec.line_id

Line 406: from ic_tran_pnd itp, op_ordr_dtl ood, op_hold_cds ohc

402:
403: /* Get allocated quantity for OPSO transactions */
404: select nvl(abs(sum(nvl(trans_qty,0))),0)
405: into tempqty
406: from ic_tran_pnd itp, op_ordr_dtl ood, op_hold_cds ohc
407: where itp.item_id = pitem_id
408: and itp.lot_id = plot_id
409: and itp.whse_code = pfrom_whse_code
410: and itp.location = pfrom_location