APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on PO_HEADERS_ALL

Line 2836: PO_HEADERS_ALL POH

2832: SELECT l_key,
2833: TLP.attribute_values_tlp_id
2834: FROM PO_ATTRIBUTE_VALUES_TLP TLP,
2835: PO_LINES_ALL POL,
2836: PO_HEADERS_ALL POH
2837: WHERE TLP.po_line_id = p_po_line_id_list(i)
2838: AND p_po_line_id_list(i) <> g_NOT_REQUIRED_ID
2839: AND POL.po_line_id = TLP.po_line_id
2840: AND POH.po_header_id = POL.po_header_id

Line 3446: l_default_lang PO_HEADERS_ALL.created_language%TYPE;

3442: IS
3443: d_mod CONSTANT VARCHAR2(100) := D_create_default_attr_tlp;
3444: l_progress VARCHAR2(4);
3445:
3446: l_default_lang PO_HEADERS_ALL.created_language%TYPE;
3447: l_description PO_ATTRIBUTE_VALUES_TLP.description%TYPE;
3448: l_long_description PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE;
3449: BEGIN
3450: l_progress := '010';

Line 3471: FROM PO_HEADERS_ALL POH,

3467: -- SQL Why : To create a default Attr TLP row for the default language
3468: -- SQL Join: po_line_id, po_header_id
3469: SELECT POH.created_language
3470: INTO l_default_lang
3471: FROM PO_HEADERS_ALL POH,
3472: PO_LINES_ALL POL
3473: WHERE POH.po_header_id = POL.po_header_id
3474: AND POL.po_line_id = p_po_line_id;
3475: ELSE

Line 3610: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

3606: IS
3607: d_mod CONSTANT VARCHAR2(100) := D_create_default_attributes;
3608: l_progress VARCHAR2(4);
3609:
3610: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
3611: -- Bug 7039409: Declared new variables
3612: l_manufacturer_part_num PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE;
3613: l_manufacturer PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE;
3614: l_lead_time PO_ATTRIBUTE_VALUES.lead_time%TYPE;

Line 3638: FROM PO_HEADERS_ALL POH,

3634: -- SQL Why : To check if it BLANKET or QUOTATION or not
3635: -- SQL Join: po_line_id
3636: SELECT POH.type_lookup_code
3637: INTO l_type_lookup_code
3638: FROM PO_HEADERS_ALL POH,
3639: PO_LINES_ALL POL
3640: WHERE POL.po_line_id = p_po_line_id
3641: AND POH.po_header_id = POL.po_header_id;
3642: ELSE

Line 3755: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

3751: d_mod CONSTANT VARCHAR2(100) := D_create_default_attributes_MI;
3752: l_progress VARCHAR2(4);
3753: l_manufacturer_part_num PO_ATTRIBUTE_VALUES.MANUFACTURER_PART_NUM%TYPE;
3754: l_proc_lead_time PO_ATTRIBUTE_VALUES.LEAD_TIME%TYPE;
3755: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
3756: BEGIN
3757: l_progress := '010';
3758:
3759: IF PO_LOG.d_proc THEN

Line 4118: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

4114: IS
4115: d_mod CONSTANT VARCHAR2(100) := D_update_attributes||'_MI';
4116: l_progress VARCHAR2(4);
4117:
4118: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
4119: l_orig_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;
4120: l_orig_item_description PO_ATTRIBUTE_VALUES_TLP.description%TYPE;
4121: l_manufacturer_part_num PO_ATTRIBUTE_VALUES.MANUFACTURER_PART_NUM%TYPE;
4122: l_orig_long_desc PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE;

Line 4481: PO_HEADERS_ALL POH

4477: SELECT POLD.po_line_id, TLP.attribute_values_tlp_id
4478: BULK COLLECT INTO l_po_line_id_list, l_tlp_id_list
4479: FROM PO_LINES_DRAFT_ALL POLD,
4480: PO_ATTRIBUTE_VALUES_TLP TLP,
4481: PO_HEADERS_ALL POH
4482: WHERE POLD.draft_id = p_draft_id
4483: AND NVL(POLD.change_accepted_flag, 'Y') = 'Y'
4484: AND POLD.po_line_id = TLP.po_line_id
4485: AND POH.po_header_id = POLD.po_header_id

Line 4800: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

4796: IS
4797: d_mod CONSTANT VARCHAR2(100) := D_update_attributes;
4798: l_progress VARCHAR2(4);
4799:
4800: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
4801: l_orig_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;
4802: l_orig_item_description PO_ATTRIBUTE_VALUES_TLP.description%TYPE;
4803: l_orig_long_description PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE;
4804: l_long_description MTL_SYSTEM_ITEMS_TL.long_description%TYPE;

Line 4830: FROM PO_HEADERS_ALL POH,

4826: -- SQL Why : To check if it BLANKET or QUOTATION or not
4827: -- SQL Join: po_line_id
4828: SELECT POH.type_lookup_code
4829: INTO l_type_lookup_code
4830: FROM PO_HEADERS_ALL POH,
4831: PO_LINES_ALL POL
4832: WHERE POL.po_line_id = p_po_line_id
4833: AND POH.po_header_id = POL.po_header_id;
4834: ELSE