Sql query to get po details in oracle apps

SELECT ph.segment1 po_num, ph.creation_date, hou.NAME "Operating Unit",

        ppx.full_name "Buyer Name", ph.type_lookup_code "PO Type",

        plc.displayed_field "PO Status", ph.comments, pl.line_num,

        plt.order_type_lookup_code "Line Type", msi.segment1 "Item Code",

        pl.item_description, pl.unit_meas_lookup_code "UOM",

        pl.base_unit_price, pl.unit_price, pl.quantity,

        ood.organization_code "Shipment Org Code",

        ood.organization_name "Shipment Org Name", pv.vendor_name supplier,

        pvs.vendor_site_code, (pl.unit_price * pl.quantity) "Line Amount",

        prh.segment1 req_num, prh.type_lookup_code req_method,

        ppx1.full_name "Requisition requestor"

   FROM po_headers_all ph,

        po_lines_all pl,

        po_distributions_all pda,

        po_vendors pv,

        po_vendor_sites_all pvs,

        po_distributions_all pd,

        po_req_distributions_all prd,

        po_requisition_lines_all prl,

        po_requisition_headers_all prh,

        hr_operating_units hou,

        per_people_x ppx,

        mtl_system_items_b msi,

        po_line_types_b plt,

        org_organization_definitions ood,

        per_people_x ppx1,

        po_lookup_codes plc

  WHERE 1 = 1

    AND ph. vendor_id = pv.vendor_id

    AND PH.ORG_ID=:P_ORG_ID

    AND ph.po_header_id = pl.po_header_id

    AND ph.vendor_site_id = pvs.vendor_site_id

    AND ph.po_header_id = pd.po_header_id

    AND pl.po_line_id = pd.po_line_id

    AND pd.req_distribution_id = prd.distribution_id(+)

    AND prd.requisition_line_id = prl.requisition_line_id(+)

    AND prl.requisition_header_id = prh.requisition_header_id(+)

    AND hou.organization_id = ph.org_id

    AND ph.agent_id = ppx.person_id

    AND pda.po_header_id = ph.po_header_id

    AND pda.po_line_id = pl.po_line_id

    AND pl.line_type_id = plt.line_type_id

    AND ood.organization_id = pda.destination_organization_id

    AND ppx1.person_id(+) = prh.preparer_id

    AND pda.destination_organization_id = msi.organization_id(+)

    AND msi.inventory_item_id = NVL (pl.item_id, msi.inventory_item_id)

    AND plc.lookup_type = 'DOCUMENT STATE'

    AND plc.lookup_code = ph.closed_code

Create Zip file Backup with CMD Script

/*

BackScript.cmd

CreateBy mFaisal- 11-Feb-2020

Execute this script for creating one zip file of

multiple files from multiple directories

*/

@echo off

d:

cd D:\SRL-Common\Backup

zip -r Backup_%Date:~-7,2%_%date:~4,2%_%date:~-4%_%time:~0,2%_%Time:~3,2% D:\SRL-Common\Development D:\SRL-Common\Documentation D:\SRL-Common\Query

pause

Create ZIp file backup with CMD

zip -r Backup_%Date:~-7,2%_%date:~4,2%_%date:~-4%_%time:~0,2%_%Time:~3,2% D:\SRL-Common\Development

create file with timestamp Using CMD

mkdir Backup_%Date:~-7,2%_%date:~4,2%_%date:~-4%_%time:~0,2%_%Time:~3,2%

Result: Backup_11_02_2020_11_08

Format date and time in a Windows batch script

@ECHO OFF
: Sets the proper date and time stamp with 24Hr Time for log file naming
: convention

SET HOUR=%time:~0,2%
SET dtStamp9=%date:~-4%%date:~4,2%%date:~7,2%_0%time:~1,1%%time:~3,2%%time:~6,2% 
SET dtStamp24=%date:~-4%%date:~4,2%%date:~7,2%_%time:~0,2%%time:~3,2%%time:~6,2%

if "%HOUR:~0,1%" == " " (SET dtStamp=%dtStamp9%) else (SET dtStamp=%dtStamp24%)

ECHO %dtStamp%

PAUSE

System Date & Time in Windos OS Command

echo %date%
Tue 02/11/2020

echo %time%
10:39:09.74

echo %date%  %time%
Tue 02/11/2020 10:39:09.74

Find Responsibility and Employee information of Form in Oracle EBS

SELECT distinct fue.user_id, fue.user_name, fue.employee_id ,paaf.assignment_number,  paaf.supervisor_id

  FROM FND_MENU_ENTRIES            FME,

       FND_RESPONSIBILITY_VL       fr,

       fnd_user_resp_groups_direct fd,

       fnd_user                    fue,

       per_all_assignments_f       paaf

 WHERE EXISTS (SELECT 'FUNCTION_ID'

          FROM FND_FORM FF, FND_FORM_FUNCTIONS F3

         WHERE FF.FORM_NAME = 'FORM_NAME'

           AND F3.FORM_ID = FF.FORM_ID

           AND F3.APPLICATION_ID = FF.APPLICATION_ID

           AND FME.FUNCTION_ID = F3.FUNCTION_ID)

   and fr.MENU_ID = fme.menu_id

   and fd.RESPONSIBILITY_ID = fr.RESPONSIBILITY_ID

   and fd.user_id = fue.user_id

   and sysdate between fue.start_date and nvl(fue.end_date, sysdate)

   and fue.employee_id is not null

   and sysdate between paaf.effective_start_date and nvl(paaf.effective_end_date, sysdate)

   and fue.employee_id = paaf.person_id