APPS.OE_CONFIG SQL Statements

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

Line: 10

        select 'Y'
        from   bom_inventory_components bic
        where  bic.bill_sequence_id = comp_common_bill_sequence_id
        and    (bic.bom_item_type = 1
                or bic.bom_item_type = 2
                or (bic.optional = 1 and bic.bom_item_type = 4)
               );

Line: 24

/*        select 'Y'
        from   bom_bill_of_materials bom
        where  bom.assembly_item_id (+) = assembly_id
        and    bom.organization_id = org_id
        and    nvl(bom.alternate_bom_designator,'-99') = nvl(alt_desg,'-99')
        and    exists (select 'Exists'
                      from   bom_inventory_components bic
                      where  bic.bill_sequence_id = bom.common_bill_sequence_id
                      and    optional = 1);*/

Line: 95

   SELECT  NVL(PRL.LIST_PRICE,SEL.LIST_PRICE)
     FROM    SO_PRICE_LISTS PRI
         ,   SO_PRICE_LIST_LINES PRL
         ,   SO_PRICE_LISTS SEC
         ,   SO_PRICE_LIST_LINES SEL
     WHERE   PRL.INVENTORY_ITEM_ID (+)= component_item_id
       AND    PRL.UNIT_CODE (+)=  primary_uom_code
       AND    PRL.PRICE_LIST_ID (+) +0  = PRI.PRICE_LIST_ID
       AND    TRUNC(SYSDATE) BETWEEN NVL(PRL.START_DATE_ACTIVE(+),TRUNC(SYSDATE))
             AND NVL(PRL.END_DATE_ACTIVE(+),TRUNC(SYSDATE))
       AND    PRI.PRICE_LIST_ID = x_price_list_id
       AND    TRUNC(SYSDATE) BETWEEN NVL(PRI.START_DATE_ACTIVE,TRUNC(SYSDATE))
             AND NVL(PRI.END_DATE_ACTIVE,TRUNC(SYSDATE))
       AND    SEL.INVENTORY_ITEM_ID (+)= component_item_id
       AND    SEL.UNIT_CODE (+)= primary_uom_code
       AND    TRUNC(SYSDATE) BETWEEN NVL(SEL.START_DATE_ACTIVE(+),TRUNC(SYSDATE))
              AND NVL(SEL.END_DATE_ACTIVE(+),TRUNC(SYSDATE))
       AND    SEC.PRICE_LIST_ID = NVL(PRI.SECONDARY_PRICE_LIST_ID,
                                    PRI.PRICE_LIST_ID)
       AND    TRUNC(SYSDATE) BETWEEN NVL(SEC.START_DATE_ACTIVE,TRUNC(SYSDATE))
              AND NVL(SEC.END_DATE_ACTIVE,TRUNC(SYSDATE))
       AND    SEL.PRICE_LIST_ID (+) +0  = SEC.PRICE_LIST_ID
       --AND    NVL(PRL.PRICING_CONTEXT,' ') = ' '
       AND    NVL(PRL.PRICING_ATTRIBUTE1,'NULL') = NVL(prc_attr1, 'NULL')
       AND    NVL(PRL.PRICING_ATTRIBUTE2,'NULL') = NVL(prc_attr2, 'NULL')
       AND    NVL(PRL.PRICING_ATTRIBUTE3,'NULL') = NVL(prc_attr3, 'NULL')
       AND    NVL(PRL.PRICING_ATTRIBUTE4,'NULL') = NVL(prc_attr4, 'NULL')
       AND    NVL(PRL.PRICING_ATTRIBUTE5,'NULL') = NVL(prc_attr5, 'NULL')
       AND    NVL(PRL.PRICING_ATTRIBUTE6,'NULL') = NVL(prc_attr6, 'NULL')
       AND    NVL(PRL.PRICING_ATTRIBUTE7,'NULL') = NVL(prc_attr7, 'NULL')
       AND    NVL(PRL.PRICING_ATTRIBUTE8,'NULL') = NVL(prc_attr8, 'NULL')
       AND    NVL(PRL.PRICING_ATTRIBUTE9,'NULL') = NVL(prc_attr9, 'NULL')
       AND    NVL(PRL.PRICING_ATTRIBUTE10,'NULL') = NVL(prc_attr10, 'NULL')
       AND    NVL(PRL.PRICING_ATTRIBUTE11,'NULL') = NVL(prc_attr11, 'NULL')
       AND    NVL(PRL.PRICING_ATTRIBUTE12,'NULL') = NVL(prc_attr12, 'NULL')
       AND    NVL(PRL.PRICING_ATTRIBUTE13,'NULL') = NVL(prc_attr13, 'NULL')
       AND    NVL(PRL.PRICING_ATTRIBUTE14,'NULL') = NVL(prc_attr14, 'NULL')
       AND    NVL(PRL.PRICING_ATTRIBUTE15,'NULL') = NVL(prc_attr15, 'NULL')
       --AND    NVL(SEL.PRICING_CONTEXT,' ') = ' '
       --AND    NVL(SEL.PRICING_ATTRIBUTE1,' ') = ' '
       --AND    NVL(SEL.PRICING_ATTRIBUTE2,' ') = ' '
       --AND    NVL(SEL.PRICING_ATTRIBUTE3,' ') = ' '
       --AND    NVL(SEL.PRICING_ATTRIBUTE4,' ') = ' '
       --AND    NVL(SEL.PRICING_ATTRIBUTE5,' ') = ' '
       --AND    NVL(SEL.PRICING_ATTRIBUTE6,' ') = ' '
       --AND    NVL(SEL.PRICING_ATTRIBUTE7,' ') = ' '
       --AND    NVL(SEL.PRICING_ATTRIBUTE8,' ') = ' '
       --AND    NVL(SEL.PRICING_ATTRIBUTE9,' ') = ' '
       --AND    NVL(SEL.PRICING_ATTRIBUTE10,' ') = ' '
       --AND    NVL(SEL.PRICING_ATTRIBUTE11,' ') = ' '
       --AND    NVL(SEL.PRICING_ATTRIBUTE12,' ') = ' '
       --AND    NVL(SEL.PRICING_ATTRIBUTE13,' ') = ' '
       --AND    NVL(SEL.PRICING_ATTRIBUTE14,' ') = ' '
       --AND    NVL(SEL.PRICING_ATTRIBUTE15,' ') = ' '
	;

Line: 152

	select LIST_PRICE_PER_UNIT
	from mtl_system_items_kfv msi
	where msi.inventory_item_id = component_item_id;

Line: 245

function CZ_AUTOSELECT_COUNT(x_system_id   IN NUMBER,
                        x_header_id   IN NUMBER,
                        x_line_id     IN NUMBER)
   RETURN NUMBER
is
        x_count number := 0;

Line: 255

   END CZ_AUTOSELECT_COUNT;