eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMPMPACT dependencies on DUAL

Line 410: SELECT gmp_matl_rep_id_s.NEXTVAL INTO X_rep_id FROM dual;

406: dbms_sql.define_column (cur_item, 3, X_category_id);
407:
408: X_row_count := dbms_sql.execute_and_fetch (cur_item);
409: IF X_row_count > 0 THEN
410: SELECT gmp_matl_rep_id_s.NEXTVAL INTO X_rep_id FROM dual;
411: G_matl_rep_id := X_rep_id;
412: X_i := 0;
413: LOOP
414: dbms_sql.column_value (cur_item, 1, X_item_id);

Line 459: FROM FND_DUAL

455: Procedure rips1usr_unbucket_report IS
456:
457: CURSOR Cur_check_dtl IS
458: SELECT 1
459: FROM FND_DUAL
460: WHERE EXISTS (SELECT matl_rep_id
461: FROM ps_ubkt_dtl
462: WHERE matl_rep_id = G_matl_rep_id) ;
463:

Line 771: ' DECODE(msi.dual_uom_control,0,0, '||

767: ' msi.primary_uom_code, '||
768: ' NULL, '||
769: ' NULL '||
770: ' )) trans_qty, '||
771: ' DECODE(msi.dual_uom_control,0,0, '||
772: ' DECODE(gmd.line_type, -1,-1,1) * DECODE(gmd.dtl_um, '||
773: ' msi.secondary_uom_code, '||
774: ' NVL((NVL(gmd.wip_plan_qty, gmd.plan_qty) - gmd.actual_qty), 0), '||
775: ' inv_convert.inv_um_convert(gmd.inventory_item_id, '||

Line 813: ' DECODE(items.dual_uom_control,0,0, '||

809: ' SELECT ' ||
810: ' mtl.requirement_date trans_date, ' ||
811: ''''||'OMSO'||''''||' doc_type, mtl.demand_source_header_id doc_id, '||
812: ' mtl.primary_uom_quantity * (-1) trans_qty, '||
813: ' DECODE(items.dual_uom_control,0,0, '||
814: ' (-1) * inv_convert.inv_um_convert(mtl.inventory_item_id, '||
815: ' NULL, '||
816: ' org.organization_id, '||
817: ' NULL, '||

Line 874: ' DECODE(msi.dual_uom_control,0,0, '||

870: ' SELECT '||
871: ' dtl.forecast_date trans_date, '||
872: ' '||''''||'FCST'||''''||' doc_type, NULL doc_id, '||
873: ' (-1) * dtl.current_forecast_quantity trans_qty, '||
874: ' DECODE(msi.dual_uom_control,0,0, '||
875: ' (-1) * inv_convert.inv_um_convert(dtl.inventory_item_id, '||
876: ' NULL, '||
877: ' dtl.organization_id, '||
878: ' NULL, '||

Line 913: ' DECODE(mitem.dual_uom_control,0,0, '||

909: ' UNION ALL '||
910: ' SELECT po.expected_delivery_date trans_date, '||''''||'PORD'||''''||' doc_type, '||
911: ' po.po_header_id doc_id, '||
912: ' po.to_org_primary_quantity trans_qty,'||
913: ' DECODE(mitem.dual_uom_control,0,0, '||
914: ' inv_convert.inv_um_convert(mitem.inventory_item_id, '||
915: ' NULL, '||
916: ' mitem.organization_id, '||
917: ' NULL, '||

Line 945: ' DECODE(mitem.dual_uom_control,0,0, '||

941: ' UNION ALL '||
942: ' SELECT po.expected_delivery_date, '||''''||'PREQ'||''''||' , '||
943: ' po.requisition_header_id, '||
944: ' po.to_org_primary_quantity,'||
945: ' DECODE(mitem.dual_uom_control,0,0, '||
946: ' inv_convert.inv_um_convert(mitem.inventory_item_id, '||
947: ' NULL, '||
948: ' mitem.organization_id, '||
949: ' NULL, '||

Line 977: ' DECODE(mitem.dual_uom_control,0,0, '||

973: ' UNION ALL'||
974: ' SELECT po.expected_delivery_date trans_date, '||''''||'PRCV'||''''||' doc_type, '||
975: ' po.po_header_id doc_id, '||
976: ' po.to_org_primary_quantity trans_qty,'||
977: ' DECODE(mitem.dual_uom_control,0,0, '||
978: ' inv_convert.inv_um_convert(mitem.inventory_item_id, '||
979: ' NULL, '||
980: ' mitem.organization_id, '||
981: ' NULL, '||

Line 1009: ' DECODE(mitem.dual_uom_control,0,0, '||

1005: ' UNION ALL'||
1006: ' SELECT po.expected_delivery_date trans_date, '||''''||'PRCV'||''''||' doc_type ,'||
1007: ' po.shipment_header_id doc_id, '||
1008: ' po.to_org_primary_quantity trans_qty,'||
1009: ' DECODE(mitem.dual_uom_control,0,0, '||
1010: ' inv_convert.inv_um_convert(mitem.inventory_item_id, '||
1011: ' NULL, '||
1012: ' mitem.organization_id, '||
1013: ' NULL, '||

Line 1037: ' DECODE(mitem.dual_uom_control,0,0, '||

1033: ' UNION ALL'||
1034: ' SELECT po.expected_delivery_date trans_date, '||''''||'SHMT'||''''||' doc_type,'||
1035: ' po.shipment_header_id doc_id, '||
1036: ' po.to_org_primary_quantity trans_qty,'||
1037: ' DECODE(mitem.dual_uom_control,0,0, '||
1038: ' inv_convert.inv_um_convert(mitem.inventory_item_id, '||
1039: ' NULL, '||
1040: ' mitem.organization_id, '||
1041: ' NULL, '||

Line 1182: SELECT SYSDATE INTO X_date FROM dual;

1178: --If balance is less than the safety stock then set critical indicator accordingly.
1179: IF (nvl(balance1,0) < nvl(G_total_ss,0)) THEN
1180: G_c_ind := '**';
1181: cleanup_details;
1182: SELECT SYSDATE INTO X_date FROM dual;
1183: X_ret := G_doc_tab(X_i).trans_date - X_date;
1184: IF (X_ret < 0) THEN
1185: X_pastdue := '*';
1186: ELSE

Line 1231: SELECT SYSDATE INTO X_date FROM dual;

1227:
1228: cleanup_details;
1229:
1230:
1231: SELECT SYSDATE INTO X_date FROM dual;
1232: X_ret := G_doc_tab(X_i).trans_date - X_date;
1233: IF (X_ret < 0) THEN
1234: X_pastdue := '*';
1235: ELSE

Line 1832: ' FROM DUAL ';

1828: ' FROM ps_matl_hdr pmh ' ||
1829: ' WHERE pmh.matl_rep_id = ' ||G_matl_rep_id||
1830: ' ORDER BY pmh.inventory_item_id, pmh.organization_id ' ||
1831: ' ) HEADER ' ||
1832: ' FROM DUAL ';
1833:
1834: --DELETE FROM GMP_UNBUCKETED_XML_GTMP;
1835: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1836:

Line 1835: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';

1831: ' ) HEADER ' ||
1832: ' FROM DUAL ';
1833:
1834: --DELETE FROM GMP_UNBUCKETED_XML_GTMP;
1835: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1836:
1837: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1838:
1839: qryctx := dbms_xmlgen.newcontext(x_stmt);