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 549: FROM dual;

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

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

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