APPS.PO_POXRRCVV_XMLP_PKG SQL Statements

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

Line: 51

	select primary_cost_method
	into l_primary_cost_method
	from mtl_parameters
	where organization_id = P_org_id ;

Line: 71

SELECT  PLC.DISPLAYED_FIELD
INTO    L_SORT_BY
FROM    PO_LOOKUP_CODES PLC
WHERE   PLC.LOOKUP_TYPE (+) = 'SRS ORDER BY'
AND     PLC.LOOKUP_CODE (+) = P_SORT_OPTION ;

Line: 84

SELECT  O.ORGANIZATION_NAME,
        NVL(EXTENDED_PRECISION, PRECISION),
        NVL(MINIMUM_ACCOUNTABLE_UNIT, POWER(10,NVL(-PRECISION,0))),
        MCS.CATEGORY_SET_NAME,
        DEFAULT_COST_TYPE_ID,
        COST_TYPE,
        PLC.DISPLAYED_FIELD,
        LU2.MEANING
INTO    L_ORGANIZATION,
        L_EXT_PREC,
        L_ROUND_UNIT,
        L_CAT_SET_NAME,
        L_DEF_COST_TYPE,
        L_COST_TYPE,
        L_SORT_BY,
        L_DETAIL_LEVEL
FROM    ORG_ORGANIZATION_DEFINITIONS O,
        FND_CURRENCIES FC,
        MTL_CATEGORY_SETS MCS,
        CST_COST_TYPES,
        PO_LOOKUP_CODES PLC,
        MFG_LOOKUPS LU2
WHERE   FC.CURRENCY_CODE = P_CURRENCY_CODE
AND     O.ORGANIZATION_ID = P_ORG_ID
AND     MCS.CATEGORY_SET_ID = P_CATEGORY_SET
AND     COST_TYPE_ID = P_COST_TYPE_ID
AND     PLC.LOOKUP_TYPE (+) = 'SRS ORDER BY'
AND     PLC.LOOKUP_CODE (+) = P_SORT_OPTION
AND     LU2.LOOKUP_TYPE (+) = 'CST_BICR_DETAIL_OPTION'
AND     LU2.LOOKUP_CODE (+) = P_RPT_OPTION;

Line: 132

SELECT  currency_code
INTO    l_fcn_currency
FROM    cst_organization_definitions cod
WHERE   cod.organization_id = P_org_id;

Line: 214

  select to_char(to_date(P_AS_OF_DATE,'YYYY/MM/DD HH24:MI:SS'),'DD-MON-YYYY HH24:MI:SS')
  into l_as_of_date
  from dual;