APPS.OE_BLANKET_WF dependencies on OE_BLANKET_HEADERS_EXT

Line 178: FROM oe_blanket_headers_all obha, oe_blanket_headers_ext obhe

174: OE_STANDARD_WF.Set_Msg_Context(actid);
175: IF (funcmode = 'RUN') then
176: SELECT obhe.Start_Date_Active, obhe.End_Date_Active
177: INTO l_start_date, l_end_date
178: FROM oe_blanket_headers_all obha, oe_blanket_headers_ext obhe
179: WHERE obha.header_id = to_number(itemkey)
180: AND obha.order_number = obhe.order_number;
181:
182: -- start date has not been reached

Line 373: FROM oe_blanket_headers_all obha, oe_blanket_headers_ext obhe

369: END;
370:
371: SELECT obhe.end_date_active
372: INTO l_end_date
373: FROM oe_blanket_headers_all obha, oe_blanket_headers_ext obhe
374: WHERE obha.header_id = l_header_id
375: AND obha.order_number = obhe.order_number;
376:
377: document := to_char(l_end_date, 'DD-MON-RRRR');

Line 432: from oe_blanket_headers_all bh, oe_blanket_headers_ext bhx

428:
429: -- set WF header attributes, values may have been changed during the wait period
430: select bh.sold_to_org_id, bhx.end_date_active, bh.salesrep_id
431: into l_sold_to_org_id, l_end_date, l_salesrep_id
432: from oe_blanket_headers_all bh, oe_blanket_headers_ext bhx
433: where bh.header_id = to_number(itemkey)
434: and bh.order_number = bhx.order_number;
435:
436: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);

Line 856: from oe_blanket_headers_all bh, oe_blanket_headers_ext bhx

852:
853: -- set WF header attributes, values may have been changed during the wait period
854: select bh.sold_to_org_id, bhx.end_date_active, bh.salesrep_id
855: into l_sold_to_org_id, l_end_date, l_salesrep_id
856: from oe_blanket_headers_all bh, oe_blanket_headers_ext bhx
857: where bh.header_id = p_header_id
858: and bh.order_number = bhx.order_number;
859:
860: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);

Line 977: from oe_blanket_headers_all bh, oe_blanket_headers_ext bhx

973: END IF;
974:
975: select bh.sold_to_org_id, bhx.end_date_active, bh.salesrep_id
976: into l_sold_to_org_id, l_end_date, l_salesrep_id
977: from oe_blanket_headers_all bh, oe_blanket_headers_ext bhx
978: where bh.header_id = p_header_id
979: and bh.order_number = bhx.order_number;
980:
981: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);

Line 1070: FROM oe_blanket_headers_all obha, oe_blanket_headers_ext obhe

1066: END IF;
1067:
1068: SELECT obhe.End_Date_Active
1069: INTO l_end_date
1070: FROM oe_blanket_headers_all obha, oe_blanket_headers_ext obhe
1071: WHERE obha.header_id = to_number(itemkey)
1072: AND obha.order_number = obhe.order_number;
1073:
1074: