APPS.PO_DATATEMPLATE_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 190: p_object_name := 'PO_LINE_LOCATIONS_ALL_EXT_B';

186: l_sql varchar2(1000);
187: begin
188: if p_doc_type = 'SHIPMENT' then
189: p_attr_group_type := 'PO_SHIPMENTS_EXT_ATTRS';
190: p_object_name := 'PO_LINE_LOCATIONS_ALL_EXT_B';
191: p_pk1_column_name := 'LINE_LOCATION_ID';
192: elsif p_doc_type = 'LINES' then
193: p_attr_group_type := 'PO_LINE_EXT_ATTRS';
194: p_object_name := 'PO_LINES_ALL_EXT_B';

Line 355: from po_line_locations_all_ext_b

351: WHERE POT.TEMPLATE_ID = POTU.TEMPLATE_ID
352: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
353: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
354: AND potu.attribute_group_id in (select distinct attr_group_id
355: from po_line_locations_all_ext_b
356: where line_location_id = p_line_location_id
357: and draft_id = p_draft_Id and uda_template_id = potu.template_id
358: and attr_group_id = potu.attribute_group_id)
359: ORDER BY POTU.ATTRIBUTE_GROUP_SEQUENCE;

Line 431: L_SQL := L_SQL || ' from po_line_locations_all_ext_vl where line_location_id = ' ||

427: L_SQL := L_SQL || ')))';
428: ELSE
429: L_SQL := L_SQL || ' ))';
430: END IF;
431: L_SQL := L_SQL || ' from po_line_locations_all_ext_vl where line_location_id = ' ||
432: p_line_location_id || ' AND draft_id = ' || p_draft_id
433: || ' and attr_group_id = ' || REC.ATTR_GROUP_ID || ')' ;
434: L_O_CTR := L_O_CTR + 1;
435: END LOOP;

Line 728: l_where_sql := ' from PO_LINE_LOCATIONS_ALL_EXT_VL where line_location_id = :1 and draft_id = :2';

724: l_address varchar2(4000);
725:
726: begin
727:
728: l_where_sql := ' from PO_LINE_LOCATIONS_ALL_EXT_VL where line_location_id = :1 and draft_id = :2';
729:
730: begin
731: SELECT ag.attr_group_id,
732: efdfce.application_column_name

Line 843: FROM PO_LINE_LOCATIONS_ALL

839:
840: IF (draftID = -1) then
841: begin
842: SELECT 1 INTO l_value
843: FROM PO_LINE_LOCATIONS_ALL
844: WHERE PO_HEADER_ID = pt_headerId
845: and rownum = 1;
846: exception
847: When no_data_found then

Line 853: l_sql_o := '(SELECT line_location_id from po_line_locations_all where PO_HEADER_ID =:1)';

849: p_fob_value_origin := '';
850: return(true);
851: end;
852:
853: l_sql_o := '(SELECT line_location_id from po_line_locations_all where PO_HEADER_ID =:1)';
854: l_first_bind := pt_headerId;
855: l_draftId := -1;
856:
857: else

Line 877: || 'FROM PO_LINE_LOCATIONS_All_ext_b WHERE line_location_id IN '

873: l_draftId := draftId;
874: end if;
875:
876: l_sql_d := '(SELECT COUNT(NVL( ' || l_col_name || ' , ''N'')) '
877: || 'FROM PO_LINE_LOCATIONS_All_ext_b WHERE line_location_id IN '
878: || l_sql_o
879: || ' and draft_id = :2 and attr_group_id =:3 AND '
880: || ' DECODE( NVL(' || l_col_name || ', ''N''), ''OSP'', ''Origin'', ''OAL'', ''Origin'',
881: NVL(' || l_col_name || ', ''N'')) <> :4)';

Line 1085: FROM PO_LINE_LOCATIONS_ALL

1081: l_enc_amt NUMBER;
1082: CURSOR cur_shipments IS
1083: SELECT line_location_id,
1084: shipment_type
1085: FROM PO_LINE_LOCATIONS_ALL
1086: WHERE po_header_id = p_header_id;
1087:
1088: CURSOR cur_distributions (line_loc_id NUMBER) IS
1089: SELECT rate,