DBA Data[Home] [Help]

APPS.INV_KANBAN_PKG dependencies on WIP_ENTITIES

Line 124: FROM wip_entities h

120: AND h.header_id = l.header_id;
121: ELSIF v_document_type_id = 5 THEN /* Wip Discrete Job */
122: SELECT h.wip_entity_name
123: INTO v_document_header
124: FROM wip_entities h
125: WHERE h.wip_entity_id = v_document_header_id;
126: ELSIF v_document_type_id = 6 THEN /* Rep Schedule */
127: SELECT h.wip_entity_name
128: INTO v_document_header

Line 129: FROM wip_entities h

125: WHERE h.wip_entity_id = v_document_header_id;
126: ELSIF v_document_type_id = 6 THEN /* Rep Schedule */
127: SELECT h.wip_entity_name
128: INTO v_document_header
129: FROM wip_entities h
130: WHERE h.wip_entity_id = v_document_header_id;
131: ELSIF v_document_type_id = 7 THEN /* Flow Schedule */
132: SELECT h.wip_entity_name
133: INTO v_document_header

Line 134: FROM wip_entities h

130: WHERE h.wip_entity_id = v_document_header_id;
131: ELSIF v_document_type_id = 7 THEN /* Flow Schedule */
132: SELECT h.wip_entity_name
133: INTO v_document_header
134: FROM wip_entities h
135: WHERE h.wip_entity_id = v_document_header_id;
136: ELSIF v_document_type_id = 8 THEN /* Lot based Job*/
137: SELECT h.wip_entity_name
138: INTO v_document_header

Line 139: FROM wip_entities h

135: WHERE h.wip_entity_id = v_document_header_id;
136: ELSIF v_document_type_id = 8 THEN /* Lot based Job*/
137: SELECT h.wip_entity_name
138: INTO v_document_header
139: FROM wip_entities h
140: WHERE h.wip_entity_id = v_document_header_id;
141: END IF;
142:
143: RETURN v_document_header;