APPS.PKG_GMP_BUCKET_DATA dependencies on DUAL

Line 51: FROM dual;

47: FROM ps_matl_hdr
48: WHERE matl_rep_id = V_matl_rep_id;
49: CURSOR Cur_matl_rep_id IS
50: SELECT gem5_matl_rep_id_s.NEXTVAL
51: FROM dual;
52: X_rows NUMBER DEFAULT 0;
53: prior_to_one NUMBER DEFAULT 0;
54: X_trans_date DATE;
55: X_qty NUMBER DEFAULT 0;

Line 547: FROM dual;

543: FROM ps_matl_hdr
544: WHERE matl_rep_id = V_matl_rep_id;
545: CURSOR Cur_matl_rep_id IS
546: SELECT gem5_matl_rep_id_s.NEXTVAL
547: FROM dual;
548: X_rows NUMBER DEFAULT 0;
549: X_trans_date DATE;
550: X_qty NUMBER DEFAULT 0;
551: X_qty2 NUMBER DEFAULT 0;

Line 630: /* ' DECODE(msi.dual_uom_control,0,0, '||

626: ' NULL, '||
627: ' NULL '||
628: ' ) '||
629: ' ) trans_qty, '||
630: /* ' DECODE(msi.dual_uom_control,0,0, '||
631: ' DECODE(gmd.line_type, -1,-1,1) * DECODE(gmd.dtl_um, '||
632: ' msi.secondary_uom_code, '||
633: ' (gmd.wip_plan_qty - gmd.actual_qty), '||
634: ' inv_convert.inv_um_convert(gmd.inventory_item_id, '||