Oracle apps EBS r12 Report for the HRMS and
Payroll Report - Report Name - Introduction Letter Bank and Advice Depot
Template
File - RTF File Design :
Download the Format of
the RTF File means Template File:
https://drive.google.com/file/d/1ROeHeJWTifCENxrwwlH7D9uwE1GSvJXb/view?usp=sharing
Format Like This.
F IF
DATE
The Manager
ADDR1
ADDR2
ADDR3
ADDR4
ADDR5
Subject: SUB
Dear Sir,
We would request you to transfer Tk. (Taka AMT)
only from our Account No. ACNT and credit the individual account with the
amount mentioned against each name in the attached schedule IFIFmaintained with PERSON_BANK_CODE, through Bangladesh Bank Electronic
Fund Transfer Network (BEFTN).EIFIFmaintained with PERSON_BANK_CODE, through Bangladesh Bank
Electronic Fund Transfer Network (BEFTN).
EIFIFmaintained with PERSON_BANK_CODE, through Bangladesh Bank
Electronic Fund Transfer Network (BEFTN).
EIF
IF
Thanking you,
Yours
faithfully,
FAITH
AUTHORISED SIGNATURE AUTHORISED
SIGNATURE
EIF
IF XX PHARMACEUTICALS LIMITED
INTERNAL
COMMUNICATION
From : Accounts Department
To : Depot In Charge, Payment_mthd
Date : DATE
Subject : Payment of SUB
Please disburse the SUB of TK. to the Field Forces/ Depot Officials.
Kindly send back the money RECEIPT for adjustment in the books of accounts.
Regards
Authorized Signature
|
EIF
EF
-----------------------------------------------------------------------------------------------
---------------------------------- XXBEX_TEMP_EMP_REV.xml
--------------------------
Data
Definition File :
Download the Format of
the Data Definition File :
https://drive.google.com/file/d/1yYjZkST9BqDyjWkiy6FCqhp_cjsbYeRk/view?usp=sharing
<?xml
version="1.0" encoding="UTF-8" ?>
<dataTemplate
name="XXBEX_INT_LETTER_BNK_ADV_DEPOT" version="1.0">
<properties>
<property
name="xml_tag_case" value="upper" />
</properties>
<parameters>
<parameter
name="P_PAYROLL_ID" dataType =
"VARCHAR2"></parameter>
<parameter
name="P_IN_CHR_PERIOD" dataType =
"VARCHAR2"></parameter>
<parameter
name="P_IN_ORG_PAY_METHOD" dataType =
"varchar2"></parameter>
<parameter
name="P_IN_CONSOLIDATION_SET" dataType =
"varchar2"></parameter>
<parameter
name="P_IN_PAY_ACTION_ID" dataType =
"varchar2"></parameter>
<parameter name="P_IN_CHR_SUBJECT"
dataType = "varchar2"></parameter>
</parameters>
<dataQuery>
<sqlStatement
name="Q_LETTER">
<![CDATA[
SELECT
--
upper(decode(:P_IN_CHR_COMPANY,'BAIL','Bangladesh Antibiotic Industries
Ltd.', 'BPL','Beximco Pharmaceuticals Ltd.','IIS','I'
-- ||'&'
-- ||'I Services Ltd.','PCL','Pharmatek
Chemicals Ltd.','SPL','Shuktara Printers Ltd.')) company_name,
decode((select PAYROLL_NAME
from pay_all_payrolls_f pay
where
pay.payroll_id=xx.PAYROLL_ID),'BPL Monthly Payroll','Beximco Pharmaceuticals
Ltd.'
,'BAIL Monthly Payroll','Bangladesh Antibiotic Industries Ltd.'
,'BPL Top Management Monthly Payroll','Beximco Pharmaceuticals Ltd.'
,'IIS Monthly Payroll','I&I Services Ltd.'
,'PCL Monthly Payroll','Pharmatek Chemicals Ltd.'
,'SPL Monthly Payroll','Shuktara Printers Ltd.'
,'Expatriate Monthly
Payroll','Beximco Pharmaceuticals Ltd.') company_name,
:P_IN_CHR_SUBJECT subject,
decode(xx.org_bank_code,'CASH',to_char(SYSDATE,'DD Mon
YYYY'),to_char(SYSDATE,'Mon DD, YYYY')) print_date,
-- xx.org_payment_method_id,
xx.org_payment_method_name, -- Added on 19-Sep-2017
xx.account_num,
xx.org_bank,
xx.org_bank_code,
person_bank_code,
xx.amount,
xxbex_num_to_word_convert_func(xx.amount)
amt_in_words,
case
when xx.count_emp > 1 then
'receipts'
when xx.count_emp =1 then
'receipt'
end receipt, -- Added on 19-Sep-2017
xx.PAYROLL_ID,
flv.ATTRIBUTE1,
flv.ATTRIBUTE2,
flv.ATTRIBUTE3,
flv.ATTRIBUTE4,
flv.ATTRIBUTE5
FROM
(SELECT ppp.org_payment_method_id,
popm.org_payment_method_name,
orgacc.segment4 account_num,
orgacc.segment1 org_bank,
nvl(regexp_substr(upper(orgacc.segment1),'HSBC|IFIC|CITY'),'CASH')
org_bank_code,
nvl(regexp_substr(upper(persnacc.segment1),'HSBC|IFIC|CITY|STATE'),'CASH')
person_bank_code,
paaf.PAYROLL_ID,
sum(ppp.VALUE) amount,
count(paaf.ASSIGNMENT_NUMBER) count_emp
FROM pay_pre_payments ppp ,
pay_assignment_actions paa,
per_all_assignments_f paaf, -- Added on 19-Sep-2017
pay_payroll_actions ppa,
pay_org_payment_methods_f popm,
pay_personal_payment_methods_f pppm,
pay_external_accounts orgacc,
pay_external_accounts persnacc,
pay_payment_types_tl ppt
WHERE 1 =1
AND ppp.assignment_action_id = paa.assignment_action_id
AND ppa.payroll_action_id = paa.payroll_action_id
and paa.ASSIGNMENT_ID = paaf.ASSIGNMENT_ID
and ppa.effective_date between
paaf.EFFECTIVE_START_DATE and paaf.EFFECTIVE_END_DATE
and ppa.effective_date between
pppm.EFFECTIVE_START_DATE and pppm.EFFECTIVE_END_DATE -- Added on 20-Mar-2018
AND popm.org_payment_method_id = ppp.org_payment_method_id
AND popm.external_account_id = orgacc.external_account_id(+)
AND ppp.personal_payment_method_id =pppm.personal_payment_method_id(+)
AND pppm.external_account_id = persnacc.external_account_id(+)
AND ppt.payment_type_id = popm.payment_type_id
AND ppt.language ='US'
and paaf.PAYROLL_ID =
nvl(:p_payroll_id,paaf.PAYROLL_ID)
AND paa.payroll_action_id
=nvl(:P_IN_PAY_ACTION_ID,paa.payroll_action_id)--125165
AND ppa.consolidation_set_id = nvl(:P_IN_CONSOLIDATION_SET,ppa.consolidation_set_id)
AND
to_char(ppa.effective_date,'MON-YY')=nvl(:P_IN_CHR_PERIOD,to_char(ppa.effective_date,'MON-YY'))
AND ppp.org_payment_method_id =
nvl(:P_IN_ORG_PAY_METHOD,ppp.org_payment_method_id)
GROUP BY ppp.org_payment_method_id,
popm.org_payment_method_name,
orgacc.segment4,
orgacc.segment1,
nvl(regexp_substr(upper(orgacc.segment1),'HSBC|IFIC|CITY'),'CASH'),
nvl(regexp_substr(upper(persnacc.segment1),'HSBC|IFIC|CITY|STATE'),'CASH'),
paaf.PAYROLL_ID
) xx,FND_LOOKUP_VALUES flv --- Lookup values for Orgnization
Bank
where xx.ORG_BANK=flv.MEANING
and
flv.LOOKUP_TYPE='XXBEX_BANK_PAYMENT_METHOD_LOOK'
]]>
</sqlStatement>
</dataQuery>
<dataStructure>
<group name="G_LETTER"
dataType="varchar2" source="Q_LETTER">
<element name="COMPANY_NAME" dataType="varchar2"
value="COMPANY_NAME"/>
<element
name="SUBJECT" dataType="varchar2"
value="SUBJECT"/>
<element
name="PRINT_DATE" dataType="varchar2"
value="PRINT_DATE"/>
<element
name="org_payment_method_name" dataType="varchar2"
value="org_payment_method_name"/>
<element
name="ACCOUNT_NUM" dataType="varchar2"
value="ACCOUNT_NUM"/>
<element
name="ORG_BANK" dataType="varchar2" value="ORG_BANK"/>
<element
name="ORG_BANK_CODE" dataType="varchar2"
value="ORG_BANK_CODE"/>
<element
name="PERSON_BANK_CODE" dataType="varchar2"
value="PERSON_BANK_CODE"/>
<element
name="AMOUNT" dataType="varchar2"
value="AMOUNT"/>
<element name="AMT_IN_WORDS"
dataType="varchar2" value="AMT_IN_WORDS"/>
<element
name="receipt" dataType="varchar2"
value="receipt"/>
<element
name="ATTRIBUTE1" dataType="varchar2"
value="ATTRIBUTE1"/>
<element
name="ATTRIBUTE2" dataType="varchar2" value="ATTRIBUTE2"/>
<element
name="ATTRIBUTE3" dataType="varchar2"
value="ATTRIBUTE3"/>
<element
name="ATTRIBUTE4" dataType="varchar2"
value="ATTRIBUTE4"/>
<element
name="ATTRIBUTE5" dataType="varchar2"
value="ATTRIBUTE5"/>
</group>
</dataStructure>
</dataTemplate>
----------------------------------
End----------------
Download the Format of
the XXBEX_INT_LETTER_BNK_ADV_DEPOT.rtf::
Download the Format of
the XXBEX_INT_LETTER_BNK_ADV_DEPOT.xml ::
https://drive.google.com/file/d/1yYjZkST9BqDyjWkiy6FCqhp_cjsbYeRk/view?usp=sharing
Download the Format of
the
XXBEX_INT_LETTER_BNK_ADV_DEPOT_CP.ldt::
https://drive.google.com/file/d/16pgavKAGuEjG9IK6zeFg31egHcu9rSXp/view?usp=sharing
Download the Format of
the
XXBEX_INT_LETTER_BNK_ADV_DEPOT_DD.ldt ::
https://drive.google.com/file/d/13-DgkzPY1-EKlZtoGvkgwml_iu_a4N_Q/view?usp=sharing
Download the Format of
the
XXBEX_INT_LETTER_BNK_ADV_DEPOT_REQ.ldt::
https://drive.google.com/file/d/1Zbe6hloY5SUtErfnIRAl5-qp9-c76tBp/view?usp=sharing
No comments:
Post a Comment