APPS.INV_RCV_DIAG_LCM_01 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 35

   JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 38

   JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 39

   JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORGANIZATION_DEFINITIONS[Top]');

Line: 40

   sqltxt :=     ' SELECT ood.*' ||
                 ' FROM   org_organization_definitions ood , mtl_parameters mp, rcv_parameters rp'  ||
    	         ' WHERE  ood.organization_id = mp.organization_id' ||
		 ' AND    mp.organization_id = rp.organization_id' ||
                 ' AND    mp.lcm_enabled_flag = ''N'' ' ||
		 ' AND    rp.pre_receive = ''Y'' ';

Line: 51

   JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 52

   JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS[Top]');

Line: 53

   sqltxt :=     ' SELECT mp.*' ||
                 ' FROM   org_organization_definitions ood , mtl_parameters mp, rcv_parameters rp'  ||
    	         ' WHERE  ood.organization_id = mp.organization_id' ||
		 ' AND    mp.organization_id = rp.organization_id' ||
                 ' AND    mp.lcm_enabled_flag = ''N'' ' ||
		 ' AND    rp.pre_receive = ''Y'' ';

Line: 63

   JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 64

   JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS[Top]');

Line: 65

   sqltxt :=     ' SELECT rp.*' ||
                 ' FROM   org_organization_definitions ood , mtl_parameters mp, rcv_parameters rp'  ||
    	         ' WHERE  ood.organization_id = mp.organization_id' ||
		 ' AND    mp.organization_id = rp.organization_id' ||
                 ' AND    mp.lcm_enabled_flag = ''N'' ' ||
		 ' AND    rp.pre_receive = ''Y'' ';