DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 6735: FROM WF_ITEM_ATTRIBUTE_VALUES

6731:
6732: BEGIN
6733: SELECT NUMBER_VALUE
6734: INTO l_user_id
6735: FROM WF_ITEM_ATTRIBUTE_VALUES
6736: WHERE ITEM_KEY = to_char(p_line_rec.line_id)
6737: AND ITEM_TYPE = 'OEOL'
6738: AND NAME = 'USER_ID';
6739:

Line 6742: FROM WF_ITEM_ATTRIBUTE_VALUES

6738: AND NAME = 'USER_ID';
6739:
6740: SELECT NUMBER_VALUE
6741: INTO l_resp_id
6742: FROM WF_ITEM_ATTRIBUTE_VALUES
6743: WHERE ITEM_KEY = to_char(p_line_rec.line_id)
6744: AND ITEM_TYPE = 'OEOL'
6745: AND NAME = 'RESPONSIBILITY_ID';
6746:

Line 6749: FROM WF_ITEM_ATTRIBUTE_VALUES

6745: AND NAME = 'RESPONSIBILITY_ID';
6746:
6747: SELECT NUMBER_VALUE
6748: INTO l_appl_id
6749: FROM WF_ITEM_ATTRIBUTE_VALUES
6750: WHERE ITEM_KEY = to_char(p_line_rec.line_id)
6751: AND ITEM_TYPE = 'OEOL'
6752: AND NAME = 'APPLICATION_ID';
6753: