22: l_api_name VARCHAR2(30);
23: l_progress VARCHAR2(3);
24:
25: l_person_id HZ_PARTIES.party_id%TYPE;
26: l_grantee_key FND_GRANTS.grantee_key%TYPE;
27: BEGIN
28: l_api_name := 'build_summary_outquery';
29: l_progress := '000';
30:
145: FUN_TRX_HEADERS FTH_REV,
146: HZ_PARTIES RECI_P,
147: XLE_ENTITY_PROFILES XLE1,
148: FND_LOOKUP_VALUES LKUP1,
149: FND_GRANTS FG,
150: FND_OBJECT_INSTANCE_SETS FOIS,
151: HZ_RELATIONSHIPS HZR,
152: HZ_ORG_CONTACTS HZC,
153: HZ_ORG_CONTACT_ROLES HZCR
293: l_acc_segment fnd_id_flex_segments.application_column_name%TYPE;
294:
295:
296: l_person_id HZ_PARTIES.party_id%TYPE;
297: l_grantee_key FND_GRANTS.grantee_key%TYPE;
298: BEGIN
299: l_api_name := 'build_account_outquery';
300: l_progress := '000';
301:
463: GL_LEDGERS GL0,
464: GL_LEDGERS GL1,
465: XLE_ENTITY_PROFILES XLE,
466: XLE_ENTITY_PROFILES XLE1,
467: FND_GRANTS FG,
468: FND_OBJECT_INSTANCE_SETS FOIS,
469: HZ_RELATIONSHIPS HZR,
470: HZ_ORG_CONTACTS HZC,
471: HZ_ORG_CONTACT_ROLES HZCR
685: l_api_name VARCHAR2(30);
686: l_progress VARCHAR2(3);
687:
688: l_person_id HZ_PARTIES.party_id%TYPE;
689: l_grantee_key FND_GRANTS.grantee_key%TYPE;
690: BEGIN
691: l_api_name := 'build_summary_inquery';
692: l_progress := '000';
693:
808: FUN_TRX_HEADERS FTH_REV,
809: HZ_PARTIES RECI_P,
810: XLE_ENTITY_PROFILES XLE1,
811: FND_LOOKUP_VALUES LKUP1,
812: FND_GRANTS FG,
813: FND_OBJECT_INSTANCE_SETS FOIS
814: WHERE FTH.batch_id(+) = FTB.batch_id
815: AND XLE.legal_entity_id = FTB.from_le_id
816: AND LKUP.lookup_type = ''FUN_BATCH_STATUS''
940:
941: l_acc_segment fnd_id_flex_segments.application_column_name%TYPE;
942:
943: l_person_id HZ_PARTIES.party_id%TYPE;
944: l_grantee_key FND_GRANTS.grantee_key%TYPE;
945: BEGIN
946: l_api_name := 'build_account_inquery';
947: l_progress := '000';
948:
1109: GL_LEDGERS GL0,
1110: GL_LEDGERS GL1,
1111: XLE_ENTITY_PROFILES XLE,
1112: XLE_ENTITY_PROFILES XLE1,
1113: FND_GRANTS FG,
1114: FND_OBJECT_INSTANCE_SETS FOIS
1115: WHERE fdl.ccid = glcc.code_combination_id
1116: AND glcc.account_type = lkup.lookup_code
1117: AND lkup.lookup_type =''ACCOUNT_TYPE''