DBA Data[Home] [Help]

APPS.INV_UI_ITEM_ATT_LOVS dependencies on RCV_PARAMETERS

Line 61: from RCV_PARAMETERS

57: -- End if
58:
59: select nvl(ENFORCE_RMA_SERIAL_NUM,'N')
60: into l_enforce_rma_sn
61: from RCV_PARAMETERS
62: where organization_id = p_organization_id;
63:
64: IF ( l_enforce_rma_sn = 'Y' and p_oe_order_header_id is not null) THEN
65:

Line 3713: rcv_parameters. This is called before firing

3709:
3710:
3711: /* Bug 4574714-Added the procedure to insert into temp table
3712: based on the ENFORCE_RMA_SERIAL_NUM value in
3713: rcv_parameters. This is called before firing
3714: the LOV query for serials for RMA*/
3715:
3716:
3717: PROCEDURE insert_temp_table_for_serials

Line 3753: from RCV_PARAMETERS

3749: x_returnSerialVal:='N';
3750:
3751: select nvl(ENFORCE_RMA_SERIAL_NUM,'N')
3752: into l_enforce_rma_sn
3753: from RCV_PARAMETERS
3754: where organization_id = p_organization_id;
3755:
3756:
3757: IF ( l_enforce_rma_sn = 'Y' and p_oe_order_header_id is not null) THEN

Line 3977: rcv_parameters. This is called before firing

3973: /* End of Bug 4703782 */
3974:
3975: /* Bug 5577789-Added the procedure to insert into temp table
3976: based on the ENFORCE_RMA_SERIAL_NUM value in
3977: rcv_parameters. This is called before firing
3978: the LOV query for serials for RMA. This is for the deliver step*/
3979:
3980:
3981: PROCEDURE insert_RMA_serials_for_deliver

Line 4017: from RCV_PARAMETERS

4013: x_returnSerialVal:='N';
4014:
4015: select nvl(ENFORCE_RMA_SERIAL_NUM,'N')
4016: into l_enforce_rma_sn
4017: from RCV_PARAMETERS
4018: where organization_id = p_organization_id;
4019:
4020:
4021: IF ( l_enforce_rma_sn = 'Y' and p_oe_order_header_id is not null) THEN