APPS.POS_REVISION_DIFFERENCES dependencies on PO_PRICE_DIFFERENTIALS_ARCHIVE

Line 1009: FROM po_price_differentials_archive pdiff1,po_lines_all pol

1005: PDIFF1.CREATION_DATE ,
1006: PDIFF1.LAST_UPDATED_BY ,
1007: PDIFF1.LAST_UPDATE_DATE ,
1008: PDIFF1.LAST_UPDATE_LOGIN
1009: FROM po_price_differentials_archive pdiff1,po_lines_all pol
1010: WHERE
1011: pol.po_header_id = current_header_id and
1012: pol.po_line_id = pdiff1.entity_id and
1013: revision_num = (

Line 1015: FROM po_price_differentials_archive pdiff2,

1011: pol.po_header_id = current_header_id and
1012: pol.po_line_id = pdiff1.entity_id and
1013: revision_num = (
1014: SELECT MAX( pdiff2.revision_num )
1015: FROM po_price_differentials_archive pdiff2,
1016: po_lines_all pol2
1017: WHERE
1018: pol2.po_header_id = current_header_id and
1019: pol2.po_line_id = pdiff2.entity_id and

Line 1026: v_pdiff_from po_price_differentials_archive%ROWTYPE;

1022: AND pdiff1.price_differential_id = pdiff2.price_differential_id
1023: );
1024:
1025:
1026: v_pdiff_from po_price_differentials_archive%ROWTYPE;
1027: v_pdiff_to po_price_differentials_archive%ROWTYPE;
1028:
1029:
1030: v_previous_revision_num NUMBER;

Line 1027: v_pdiff_to po_price_differentials_archive%ROWTYPE;

1023: );
1024:
1025:
1026: v_pdiff_from po_price_differentials_archive%ROWTYPE;
1027: v_pdiff_to po_price_differentials_archive%ROWTYPE;
1028:
1029:
1030: v_previous_revision_num NUMBER;
1031: v_progress VARCHAR2(3);

Line 1062: FROM po_price_differentials_archive

1058: v_progress := '180';
1059:
1060: SELECT *
1061: INTO v_pdiff_from
1062: FROM po_price_differentials_archive
1063: WHERE
1064: revision_num = (
1065: SELECT MAX( revision_num )
1066: FROM po_price_differentials_archive

Line 1066: FROM po_price_differentials_archive

1062: FROM po_price_differentials_archive
1063: WHERE
1064: revision_num = (
1065: SELECT MAX( revision_num )
1066: FROM po_price_differentials_archive
1067: WHERE
1068: revision_num <= v_previous_revision_num
1069: AND price_differential_id = v_pdiff_to.price_differential_id
1070: )

Line 1127: FROM po_price_differentials_archive pdiff1,po_line_locations_all pll

1123: PDIFF1.CREATION_DATE ,
1124: PDIFF1.LAST_UPDATED_BY ,
1125: PDIFF1.LAST_UPDATE_DATE ,
1126: PDIFF1.LAST_UPDATE_LOGIN
1127: FROM po_price_differentials_archive pdiff1,po_line_locations_all pll
1128: WHERE
1129: pll.po_header_id = current_header_id and
1130: pll.line_location_id = pdiff1.entity_id and
1131: revision_num = (

Line 1133: FROM po_price_differentials_archive pdiff2,

1129: pll.po_header_id = current_header_id and
1130: pll.line_location_id = pdiff1.entity_id and
1131: revision_num = (
1132: SELECT MAX( pdiff2.revision_num )
1133: FROM po_price_differentials_archive pdiff2,
1134: po_line_locations_all pll2
1135: WHERE
1136: pll2.po_header_id = current_header_id and
1137: pll2.line_location_id = pdiff2.entity_id and

Line 1144: v_pdiff_from po_price_differentials_archive%ROWTYPE;

1140: pdiff1.price_differential_id = pdiff2.price_differential_id
1141: );
1142:
1143:
1144: v_pdiff_from po_price_differentials_archive%ROWTYPE;
1145: v_pdiff_to po_price_differentials_archive%ROWTYPE;
1146:
1147:
1148: v_previous_revision_num NUMBER;

Line 1145: v_pdiff_to po_price_differentials_archive%ROWTYPE;

1141: );
1142:
1143:
1144: v_pdiff_from po_price_differentials_archive%ROWTYPE;
1145: v_pdiff_to po_price_differentials_archive%ROWTYPE;
1146:
1147:
1148: v_previous_revision_num NUMBER;
1149: v_progress VARCHAR2(3);

Line 1179: FROM po_price_differentials_archive

1175: v_progress := '180';
1176:
1177: SELECT *
1178: INTO v_pdiff_from
1179: FROM po_price_differentials_archive
1180: WHERE
1181: revision_num = (
1182: SELECT MAX( revision_num )
1183: FROM po_price_differentials_archive

Line 1183: FROM po_price_differentials_archive

1179: FROM po_price_differentials_archive
1180: WHERE
1181: revision_num = (
1182: SELECT MAX( revision_num )
1183: FROM po_price_differentials_archive
1184: WHERE
1185: revision_num <= v_previous_revision_num
1186: AND price_differential_id = v_pdiff_to.price_differential_id
1187: )