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 412: SELECT gmp_matl_rep_id_s.NEXTVAL INTO X_rep_id FROM dual;

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

Line 461: FROM FND_DUAL

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

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

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

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

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

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

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

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

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

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

947: ' UNION ALL '||
948: ' SELECT po.expected_delivery_date, '||''''||'PREQ'||''''||' , '||
949: ' po.requisition_header_id, '||
950: ' po.to_org_primary_quantity,'||
951: ' DECODE(mitem.dual_uom_control,0,0, '||
952: ' inv_convert.inv_um_convert(mitem.inventory_item_id, '||
953: ' NULL, '||
954: ' mitem.organization_id, '||
955: ' NULL, '||

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

979: ' UNION ALL'||
980: ' SELECT po.expected_delivery_date trans_date, '||''''||'PRCV'||''''||' doc_type, '||
981: ' po.po_header_id doc_id, '||
982: ' po.to_org_primary_quantity trans_qty,'||
983: ' DECODE(mitem.dual_uom_control,0,0, '||
984: ' inv_convert.inv_um_convert(mitem.inventory_item_id, '||
985: ' NULL, '||
986: ' mitem.organization_id, '||
987: ' NULL, '||

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

1011: ' UNION ALL'||
1012: ' SELECT po.expected_delivery_date trans_date, '||''''||'PRCV'||''''||' doc_type ,'||
1013: ' po.shipment_header_id doc_id, '||
1014: ' po.to_org_primary_quantity trans_qty,'||
1015: ' DECODE(mitem.dual_uom_control,0,0, '||
1016: ' inv_convert.inv_um_convert(mitem.inventory_item_id, '||
1017: ' NULL, '||
1018: ' mitem.organization_id, '||
1019: ' NULL, '||

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

1039: ' UNION ALL'||
1040: ' SELECT po.expected_delivery_date trans_date, '||''''||'SHMT'||''''||' doc_type,'||
1041: ' po.shipment_header_id doc_id, '||
1042: ' po.to_org_primary_quantity trans_qty,'||
1043: ' DECODE(mitem.dual_uom_control,0,0, '||
1044: ' inv_convert.inv_um_convert(mitem.inventory_item_id, '||
1045: ' NULL, '||
1046: ' mitem.organization_id, '||
1047: ' NULL, '||

Line 1188: SELECT SYSDATE INTO X_date FROM dual;

1184: --If balance is less than the safety stock then set critical indicator accordingly.
1185: IF (nvl(balance1,0) < nvl(G_total_ss,0)) THEN
1186: G_c_ind := '**';
1187: cleanup_details;
1188: SELECT SYSDATE INTO X_date FROM dual;
1189: X_ret := G_doc_tab(X_i).trans_date - X_date;
1190: IF (X_ret < 0) THEN
1191: X_pastdue := '*';
1192: ELSE

Line 1237: SELECT SYSDATE INTO X_date FROM dual;

1233:
1234: cleanup_details;
1235:
1236:
1237: SELECT SYSDATE INTO X_date FROM dual;
1238: X_ret := G_doc_tab(X_i).trans_date - X_date;
1239: IF (X_ret < 0) THEN
1240: X_pastdue := '*';
1241: ELSE

Line 1867: ' FROM DUAL ';

1863: ' FROM ps_matl_hdr pmh ' ||
1864: ' WHERE pmh.matl_rep_id = ' ||G_matl_rep_id||
1865: ' ORDER BY pmh.inventory_item_id, pmh.organization_id ' ||
1866: ' ) HEADER ' ||
1867: ' FROM DUAL ';
1868:
1869: -- DELETE FROM GMP_UNBUCKETED_XML_GTMP;
1870: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, x_stmt);
1871:

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

1897: DBMS_XMLGEN.closeContext(qryctx);
1898: DBMS_LOB.FREETEMPORARY (temp_clob);
1899: -- B7481907 Rajesh Patangya Ends
1900:
1901: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1902: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1903:
1904: INSERT INTO gmp_unbucketed_xml_temp(ubckt_matl_xml_id, xml_file) VALUES(x_seq_num, result);
1905: ps_generate_output(x_seq_num);